Skip to main content
D
Darquise12-Amethyst
12-Amethyst
July 23, 2014
Question

Report Management: Latest Version/Iteration

  • July 23, 2014
  • 1 reply
  • 1910 views

I'm building a report via Report Management. For my results I only want the most up-to-date document and display it version and iteration. Right now the way my query works is that I get the latest versions with it's latest iteration. Example: document.xml A.11 and B3. I just want B.3. Make sense?

In my Query Builder I have:

Document.Version (versionDisplayIdentifier)

Document.Latest Iteration

I searched through discussion but couldn't find the answer. It was mostly sql queries (or something like that).

Your help is appreciated

Thank you, Darquise.

1 reply

D
DmitryTsarev17-Peridot
17-Peridot
July 29, 2014

The functionality is not available OOTB in Report Builder, but you can filter out "non-latest" versions using a custom xsl for the report.

D
Darquise12-AmethystAuthor
12-Amethyst
July 29, 2014

We have Windchil Business Author - would I be able to do it with that? Note: I just haven't started using it yet!

D
DmitryTsarev17-Peridot
17-Peridot
July 29, 2014

Yes, you should be able to filter out data with Cognos too. Actually, Cognos is quite a flexible and powerful tool. It takes a while to get familiar with it, but it surely pays off in the end, if you ask me.

Feel free to ask additional question if you decide to go the Cognos way - I haven't built any reports in it for a while, but still remember a trick or two from the old days

PS We're actually in the wrong Community, so I'd suggest to contact moderators to move the discussion to the Windchill one, where you could probably get more feedback.

Terms & ConditionsCookie settingsAccessibility statement