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
------------------------------
Original Message:
Sent: 12-04-2019 11:14
From: Derek Sayres
Subject: query highest verison of document only
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
------------------------------