Multi-line search for SOReference1 / OrderID

Creation date: 14/02/2023 11:41    Updated: 14/02/2023 11:41   #order #queryscreen #soreference
Question:

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}')

  1. The soreference in this case is called soreference1. In the Data Source, select document header.
  2. Select h1. Doc order table
  3. Then put in the additional clauses like in the example. You can find this in the TEST environment.
  4. After that click on save schema.
Files