Skip to main content
14-Alexandrite
January 28, 2016
Solved

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

  • January 28, 2016
  • 3 replies
  • 1593 views

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?

Best answer by MikeLockwood

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.

3 replies

22-Sapphire I
January 28, 2016

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.

tgudobba14-AlexandriteAuthor
14-Alexandrite
January 28, 2016

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