Answered
Manuel Domingues
Looking for the JSON to retrieve info from the database on when Orders were transmitted to the factory. If there were multiple transmits, ie partials, then it should return all the results.
Something like:
https://<SERVER>/API?ajax=TransmitDate&PONumber=<CUST-PO-NUMBER>&ReleaseStatus=<Hold, Partial or Release>
Results would be
line 1 <widget> transmitted on 06/19/2020 14:35:20 status as a Partial Release
0
Comments
Please sign in to leave a comment.
The quick answer is yes! There is a ton of data stored in the OASIS database with two issues to access: 1) where it is stored and 2) interpretation of the data.
The current order state has been all but useless in a generic sense. We mark a lot of information at the line level and often "snapshot data" showing when.
There hasn't been any design work on how to present the data in JSON format outside the basics. However, there is a desire here to present the order history showing when a given line was added to the order, sent to the factory, released against, changed or canceled. The data is all there and we use the data within the transactions to help with customer needs (e.g. something incorrect was done to the order).
The only gotcha - is when? Not 100% sure just yet, but hoping before the end of 2020.