How to query the latest pdf contract from purchase agreements after a change order
Summary:
Content (please ensure you mask any confidential information):
Hi Everyone,
I currently have a query where I am selecting the Contract Number, Description, Start Date, End Date, File Name associated with the PDF, and Document ID which I am using to get the actual file through SOAP Web Service. I get the original PDF's associated with these purchase agreements, but when a change order is done, I do not get the latest PDF and I cannot seem to find it in any table.
For example, the original pdf could have the file name: PA_3000000000004_C24070_0.pdf and after a change order is done, it then changes to the file name: PA_3000000000004_C24070_1.pdf.
1