Skip to main content
18-Opal
October 25, 2018
Question

WC11 Query Builder Search for Latest Version?

  • October 25, 2018
  • 3 replies
  • 2949 views

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.

3 replies

12-Amethyst
October 25, 2018

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

 

 

 

 

1-Visitor
March 2, 2020

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.

ringo1_0-1583161159154.png

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

LawrenceS18-OpalAuthor
18-Opal
March 13, 2020

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

1-Visitor
March 13, 2020

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.

22-Sapphire I
March 13, 2020

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.