Automate

Welcome to the Automate community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  query highest verison of document only

    Posted 12-04-2019 11:15

    Hello, 
    I am querying the DRAW table, trying to find the highest version number of a document. I can query for the document, but it's returning all versions. Is there a way to find only the latest released version?

    Thanks,

    Derek



    ------------------------------
    Derek Sayres | SAP PLM Business Analyst
    ------------------------------


  • 2.  RE: query highest verison of document only

    Posted 12-09-2019 21:52
    rev sort
    ​Derek,
    I am thinking after extract using extra fields concatenate and sort by highest revision. Then using a V-look up will find the first revision of that part number. Hope this works for you or sparks another way for you.

    Winshuttle Engaged!
    Ben Kielas

    ------------------------------
    Benjamin Kielas | IT - Applications
    Generac Power Systems, Inc. | 262-544-4811
    ------------------------------



  • 3.  RE: query highest verison of document only

    Employee
    Posted 12-10-2019 12:43
    I came here to give the same recommendation actually hahah.

    You can also use the Transform functions to generate the concatenation so that whenever the script is ran it will create that as part of the run. 

    https://docs.winshuttle.com/studio-en-12-1-x-online-help-studio-w-connect/12/add-transforms-qs.htm

    ------------------------------
    James Lofgren | Solutions Engineer
    Winshuttle North America | [City] |
    ------------------------------

    Original Message