WC11 Query Builder Search for Latest Version?

[LawrenceS]

Does anyone know if WC11 has provided a simple way to build a Query Report / Search that only show the latest Version of an object? 

I have been trying to create a report and got it close to what I need but is all latest revisions (e.g. A.2, B.5, 1.3, 2.5, 3.7) when I only want the latest released version (3.7).

I have heard in previous versions of WC there is a convoluted way to do this but am hoping there is a simple way to do this...as this is already functionality in a normal WC search.

[ehowanice]

maybe I'm wrong, but unfortunately still seems to be convoluted in WC11, check out this thread:

https://community.ptc.com/t5/Windchill/Windchill-Report-Management-Query-Builder/td-p/9996

[ringo1]

On the Criteria tab, if you add a criteria that <business object>.State equals Released, that will pull in only released objects.  In addition, if you set the criteria <business object> (iterationInfo).Latest to "Yes," that will return only the latest iteration.

I am building a report that looks for several states, but excludes released and those like it.

[LawrenceS]

This sounds like this method will show all the latest of every revision.  Is that correct?

[ringo1]

That is correct; given that the lastest meets your lifecycle state criteria.  In my case; I am excluding released, so if my Rev A is released and my Rev B is in work, I pull back the latest non-released version.

[MikeLockwood]

Have to address Revision and Iteration separately.

Latest Iteration can be selected directly.

Revision is convoluted because you can make any sequence of strings or integers your custom Revision series.