Where can I find information in the database regarding the Query Builder?

[tgudobba]

We need to find the name & unique identifier for our reports.

For example, we generate a report called "ABC Report", and it displays wtDocuments created over the last week.

It displays this URL;

https://ABCCO.com/Windchill/wtcore/jsp/report/reportGenForm.jsp?oid=OR%3Awt.query.template.ReportTemplate%3A43432832&u8=…

for each of these reports, the "43432832" in this URL is unique.

Is this in the database anywhere?

[MikeLockwood · Accepted solution]

It's the IDA2A2 of the object in it's primary table.  Which may sounds greek and of no use...

Can display this in the report as /persistence/object_id/id.

[tgudobba]

So I can create a report to display information about my saved reports?

[tgudobba]

Thanks Mike! This helped me a lot!