topic Re: New qml report - find latest at one of listed states in Windchill

New qml report - find latest at one of listed states

MikeLockwood — Wed, 02 May 2018 11:11:40 GMT

I was asked to provide a report of the latest version of all drawings at either Released or Prototype Released.Search allows you to do this because the logic applied is:- (Filter out anything by state / context that you don't have READ access to)- Filter out non-latest iteration

Re: New qml report - find latest at one of listed states

lmolby — Mon, 23 Apr 2018 18:27:23 GMT

Can you share the QML of this report? Or screen shots?

Re: New qml report - find latest at one of listed states

Marco_Tosin — Tue, 24 Apr 2018 06:19:13 GMT

You can find lots of report ready to use in this document https://community.ptc.com/t5/Windchill-Questions/Resource-for-reporting/td-p/448738

Re: New qml report - find latest at one of listed states

lmolby — Tue, 24 Apr 2018 12:54:50 GMT

Except I'm still not finding what I'm looking for. I need to report that Latest Released Revision of a WTPart. There may be multiple Revisions of this part that are Released and the Latest Revision, regardless of State, may be In Work. For example:

PART12345 Rev. A.1 Released

PART12345 Rev. B.1 Released

PART12345 Rev. C.1 In Work

I want the report to send back the Latest Released Revision, which in this case is Only PART12345 Rev. B.1

The QML examples I tested came back with Blank results because the Latest, PART12345 Rev. C.1, is NOT Released.

Re: New qml report - find latest at one of listed states

Marco_Tosin — Tue, 24 Apr 2018 14:17:56 GMT

In my document there's a link to this TS article.

https://www.ptc.com/it/support/article?n=CS142076

Doesn't meet your requirements?

Re: New qml report - find latest at one of listed states

lmolby — Tue, 24 Apr 2018 14:33:50 GMT

Nope. These are the reports tested. If I want Latest Released, but the latest Rev is In Work, the report is blank, even if the previous Rev is Released.

These QMLs are filtering on the Maximum Branch ID, then filtering on the State, What I need is the opposite. I've tried adding a Sub-Select to the Sub-Select, but that doesn't seem to be supported functionality.

Re: New qml report - find latest at one of listed states

Marco_Tosin — Tue, 24 Apr 2018 14:36:47 GMT

You cannot use query builder to do recursive query.

Have you already tried to add a criteria for the state in your sub-select?

If affirmative, I suggest you to open a case with TS and ask what they would do in this particular case.

Re: New qml report - find latest at one of listed states

ocorten-2 — Mon, 21 Nov 2022 10:48:23 GMT

Hi Mike,

I am running into this same issue.

Reading the final lines it looks like Tech Support (Jaysel Meledath) supplied you with the correct sub-select to get this done.

Can you share it here as well?

Re: New qml report - find latest at one of listed states

ocorten-2 — Mon, 21 Nov 2022 11:13:55 GMT

Got it working by adding an extra criteria for State = RELEASED in the sub-select for the maximum Version Sort id

Re: New qml report - find latest at one of listed states

nimish — Thu, 19 Jun 2025 07:16:53 GMT

Hello ,

I applied the same query , i get result as expected.

but..

for few data the result is not expected its giving me the WIP data as the latest one , it should give previous released data.

any help on this issue will be appreciated.

Nimish

Re: New qml report - find latest at one of listed states

Marco_Tosin — Thu, 19 Jun 2025 07:31:18 GMT

You can't add a comment to a discussion that has an accepted solution already for two and a half years.

You'd better open another discussion, referencing this one to say it's not enough, if you want someone to be able to help you.