Query Builder Reports - returning Latest Revision

[MikeLockwood]

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?

[LiuLiang]

Please see similar post http://portal.ptcuser.org/p/fo/st/topic=16&post=85710#p85710

[MikeLockwood]

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.

[IgorMeltzer]

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

Could you write working solutions ?

[Marco_Tosin]

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

[IgorMeltzer]

this document seems to be most useful for me

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

[LiuLiang]

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.

[FeofilovIvan]

You can use JasperReports and InfoEngine query webject (or Java query similar as SQL) for create report of any complexity.