Multi-line search for SOReference1 / OrderID
Creation date: 14/02/2023 11:41
Updated: 14/02/2023 11:41
Question:
Answer:
User inform that there are 2 multiple selection on soreferences (soreference1 and soreference4).
Investigation:
We are trying to do a multi-condition search for SOReference1 (renamed here as OrderID) similar to how we do it for orderNO. However, whenever we encode multiple values, only the first entry is successfully retrieved.
Seeking guidance on how we should configure the search.
Trying to change multi-selection causes this:
Answer:
User inform that there are 2 multiple selection on soreferences (soreference1 and soreference4).
We have to make further changes.
Please refer to the document for more information.
Investigation:
The error is due to the wrong naming convention on the variable - this is the right naming ('${soReference1}')
- The soreference in this case is called soreference1. In the Data Source, select document header.
- Select h1. Doc order table
- Then put in the additional clauses like in the example. You can find this in the TEST environment.
- After that click on save schema.
DataImage67.png
DataImage7.png
DataImage90.png
Changes in shipment order query to include multi selection for soreference.docx