How can I get the date of baseline creation

[mohammed]

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

[Stefan Bolleininger]

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

[mohammed]

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

[Stefan Bolleininger]

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