Facing an issue with the workbench not capturing the correct output / details from saved query
Summary:
We are having a specific requirement to access all the related document that are associated to a specific order release.
Content (please ensure you mask any confidential information):
Consider an Order Release that has the following related objects:
- 1 Sell Shipment with 1 Bill
- 2 Buy Shipments with 2 Buy Invoices
- 1 Order Release
Each of these objects has one document uploaded, resulting in a total of 7 documents:
Object | Number of documents |
|---|---|
Order Release | 1 |
Sell Shipment | 1 |
Bill | 1 |
Buy Shipments | 2 |
Invoice | 2 |
Total | 7 |
The requirement is to display all related documents in the workbench whenever the corresponding Order Release is selected.
I have created a saved query that retrieves all documents associated with the Order Release, including documents attached to its related shipments, invoices, and bills. The query executes successfully in the SQL Servlet and returns the expected results.