Skip to main content
G
GianpaoloGallo12-Amethyst
12-Amethyst
July 11, 2024
Solved

Uncompleted Report Query builder

  • July 11, 2024
  • 2 replies
  • 2847 views
I am using Windchill PDMLink Release 11.2 and Datecode with CPS 11.2.1.7

We missed items when fetching a report in query builder. in attached picture you can find the difference between search in Windchill and export Query builder. 7 items on 15 are complely missed.

Here are the errors that I faced
no
    Best answer by MarcoTosin

    The link to the article I put up earlier refers to how to filter the LATEST version of the Production Plans.

     

    To filter also the LATEST of the WTPart you have to use the same method, with the addition that, if you have multiple views, especially if views are of different plants, you have to make a sub-select for each of them (2nd link below).

     

    How to select the latest revision of a Part in a Query Builder report in Windchill PDMLink

     

    Query Builder Report to query latest version of all WTParts in Windchill PDMLink

     

     

     

     

    2 replies

    MarcoTosin
    21-Topaz I
    MarcoTosin21-Topaz I
    21-Topaz I
    July 11, 2024

    There is no picture attached to this discussion

     

    Marco
    G
    GianpaoloGallo12-AmethystAuthor
    12-Amethyst
    July 11, 2024

    Hi Marco,

    please attached you will find the picture.

    Best regards

    Gianpaolo

    MarcoTosin
    21-Topaz I
    MarcoTosin21-Topaz I
    21-Topaz I
    July 11, 2024

    I'm pretty sure the problem is caused by a join that should have an outer join for cases where the link between tables is not true.

     

    Marco
    A
    anursinghCommunity Manager
    Community Moderator
    July 22, 2024

    Hi @GianpaoloGallo,

     

    I wanted to follow up with you on your post to see if your question has been answered. 
    If so, please mark the appropriate reply as the Accepted Solution. 
    Of course, if you have more to share on your issue, please let the Community know so that we can continue to help you. 

     

    Thanks,
    Anurag

    Terms & ConditionsAccessibility statement