Skip to main content
M
MikeLockwood22-Sapphire I
22-Sapphire I
June 18, 2010
Question

Query Builder Reports - returning Latest Revision

  • June 18, 2010
  • 4 replies
  • 3910 views

For this call: 7745852, "One can select Latest Iteration by enter a constant=1 for the criteria to get the latest Iteration.­ How does one do so for only the latest Revision?"

I got this answer: "Please note that it’s not possible to query the report using Report Manager to show Latest Revision.
For Latest iteration we have the flag set in database (i.e. constant=1) but there is no such field for Revisions as the latest revision in UI is picked up from the Revision sequence file in use."

Anyone have a work-around to get just the latest REVISION?

4 replies

L
LiuLiang1-Visitor
1-Visitor
June 22, 2010
Please see similar post http://portal.ptcuser.org/p/fo/st/topic=16&post=85710#p85710
M
MikeLockwood22-Sapphire IAuthor
22-Sapphire I
June 26, 2010

Aha!! Got an answer on this from tech support - and it works. Please see attached if interested. The key is that subselect is now available in QB Report templates.

I
IgorMeltzer10-Marble
10-Marble
July 3, 2015

I am interested in - but I do not see any attached.

Could you write working solutions ?

MarcoTosin
MarcoTosin21-Topaz I
21-Topaz I
July 3, 2015

Igor,

you can't find attachment because of the merge of ptcuser into PTC community.

They are working to adjust broken links.

Anyway, take a look at this document Resource for reporting

In it you can find a lot of query builder.

About the use of sub select you can use one of this two articles from PTC support https://support.ptc.com/appserver/cs/view/case_solution.jsp?n=CS26781&lang=en

https://support.ptc.com/appserver/cs/view/solution.jsp?n=CS33305

Marco
L
LiuLiang1-Visitor
1-Visitor
June 28, 2010

The PTC one is exact the same as what I posted earlier in above link with attached Find Latest Rev & Iteration Parts.qml.

But I found that without adding the criteria of latest rev (subselect the maximum of versionSortID), I was able to list all part's IBAs in the report, once I added the criteria of latest rev, the report generates error and I will have to remove all the IBA columns from the report.

To report the latest REVISION parts with their IBA soft attribute values, I can't make Report Manager to do that.

I had to develope sql query and ask our users to run it through discoverer report instead which is kind of pain for us.

Anyone knows how using Report Manager? Thanks.

F
FeofilovIvan1-Visitor
1-Visitor
June 29, 2010
You can use JasperReports and InfoEngine query webject (or Java query similar as SQL) for create report of any complexity.
Terms & ConditionsAccessibility statement