Skip to main content
P
ptc-43482581-Visitor
1-Visitor
March 26, 2013
Solved

Windchill Report Management (Query Builder)

  • March 26, 2013
  • 3 replies
  • 10892 views

Somebody can tell how I can create a simple query "select max(versionSortIdA2versionInfo) from WTDocument;" in Query Buider?

I'm using Windchill 10.1 M030... The problem is in the MAX function...

Thanks in advance!

3 replies

M
22-Sapphire I
MikeLockwood22-Sapphire I
22-Sapphire I
March 26, 2013

Needs to use sub-select - thru a very convoluted set of values. It is unbelievable that this is still required in ordere to get the Latest Revision. I would happily trade 1000 of the recent enhancements to Windchill to instead have a simple "Lastet Revision" pick directly in criteria.

Note: This is recommended by tech support (5 variations of it in 5 tech support calls though); not documented anywhere in the help files.

Sample QML and screen captures available if you like - not sure how to upload a file here.

P
ptc-43482581-VisitorAuthor
1-Visitor
March 26, 2013

Mike, thanks for your reply!

To get the latest Iteration is easy...

1.PNG

But in my case I want to get only the latest iteration from the last version...

2.PNG

Tip ->To upload images just click at the "camera" icon... !

H
Hugo-KTM14-Alexandrite
14-Alexandrite
July 14, 2016

I used the Maximum of the Branch Identifier instead of the SortID in a Sub-Select to get the latest iteration of the latest revision, and it seemed to work.

The SortID returned looks like a string to me, and taking the maximum of a string is ambiguous.

I also thought about converting the SortID to a number, but neither have I tried it nor do I know if it is possible.

    Marco Tosin
    21-Topaz I
    Marco Tosin21-Topaz I
    21-Topaz I
    July 14, 2016

    If you create Windchill report using Query Builder you should join this group Reporting

    You should also take a look at this document I wrote Resource for reporting

    In it you can find lots of useful information about reporting and many report ready to use (some of them are about reporting the very latest iteration).

    Marco
      M
      22-Sapphire I
      MikeLockwood22-Sapphire I
      22-Sapphire I
      July 14, 2016

      It's such a common need - filter results for both latest Iteration (easy) and latest Revision (convoluted and complex).  Seems that by now, this would be a direct selection somehow rather than having to use sub-select.  There are CS articles and other documentation recommending / showing both versionsortinfo and branchindentifier - seems that both return the same results but haven't looked at thoroughly.

        S
        21-Topaz I
        STEVEG21-Topaz I
        21-Topaz I
        July 14, 2016

        I wrote my own document on how to get the latest version so I have the exact steps.  It's 4 1/2 pages.  It's inflated though because I have images to show exactly what it should be.  Without the images it's a little over 1 page.

          Terms & ConditionsCookie settingsAccessibility statement