cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Have a PTC product question you need answered fast? Chances are someone has asked it before. Learn about the community search. X

Query Builder Reports - returning Latest Revision

MikeLockwood
22-Sapphire I

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 7
LiuLiang
4-Participant
(To: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.

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

Could you write working solutions ?

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

this document seems to be most useful for me

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

LiuLiang
4-Participant
(To:MikeLockwood)

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.

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