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

Query Builder Reports - returning Latest Revision

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?

7 replies

LiuLiang1-Visitor
1-Visitor
June 22, 2010
Please see similar post http://portal.ptcuser.org/p/fo/st/topic=16&post=85710#p85710
Translate
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.

Translate
IgorMeltzer10-Marble
10-Marble
July 3, 2015

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

Could you write working solutions ?

Translate
MarcoTosin
MarcoTosin21-Topaz II
21-Topaz II
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

Translate
Marco
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.

Translate
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.
Translate
Terms & ConditionsAccessibility statement