Sparx Systems Forum

Enterprise Architect => General Board => Topic started by: mohammed on June 10, 2013, 10:50:31 pm

Title: How can I  get the date of baseline creation
Post by: mohammed on June 10, 2013, 10:50:31 pm

How can I  get the date of baseline creation ?
what is the name of DateTime Field in Baseline ?

Title: Re: How can I  get the date of baseline creation
Post by: Stefan Bolleininger on June 10, 2013, 11:39:46 pm

Hi,

it is called "DocDate" in t_document

e.g.

Code: [Select]

SELECT Docdate  FROM `t_document` WHERE `DocType` = 'Baseline' AND ElementID LIKE \"" + DocName + "\"
This can be used,  DocName = Package.PackageGUID.

Regards

Stefan

Title: Re: How can I  get the date of baseline creation
Post by: mohammed on June 11, 2013, 12:03:47 am

I have 4 baselines
how can I get the creation date for each baseline    ?

I have got something like

string sql=   rep.SQLQuery(" SELECT Docdate  FROM 't_document' WHERE 'DocType' = 'Baseline' ");

but it does not work

Title: Re: How can I  get the date of baseline creation
Post by: Stefan Bolleininger on June 11, 2013, 12:12:41 am

Try around by yourself and after a few ideas: use that:

Code: [Select]

"SELECT Version,Notes,Docdate,Author  FROM `t_document` WHERE `DocType` = 'Baseline' AND ElementID LIKE \"" + DocName + "\" Order by Docdate desc"
But please, try around a bit before using it. The more you learn the better you are :)

Regards

Stefan