Currently, it is impossible to use row selection to get all values where a matching value is found.
As per parameter documentation:
Use "<columnName>=<columnValue> & <columnName>=<columnValue> & ...", to get the value from the first row where the specified columns have the specified values.
so indeed, you will get the first row where the value matches. However, this is not always what is required.
We would need to have, for example, all rows matching key or only the last row.
For example, if our table contains:
Account | SearchKey
1000 | customer
2000 | customer
3000 | vendor
4000 | vendor
so if we would select:
we would want for some process only the first row (this is currently how it works) : 1000
or we want all customer Accounts: 1000,2000
or we want only last row: 2000
There should be an option to indicate what you need: first, last, all
As we often use this component to retrieve values from RTX or Redwood tables which then will be used in the next SAP process, we also have the requirement to add leading zeros. Without it, SAP will not return the expected result.
For example, an Account field in SAP (GL, Customer or Vendor) are always 10 digits. So if we just would use 1000,2000 then SAP would not recognize this. We need to add leading zeros, e.g.: 0000001000,00000020000
It would ease the implementation if there is an optional parameter where you specify the total length of the result. So if you specify 10 and the returned value is 4 digits long, then 6 leading zeros are added.
No workaround was provided.
Not yet implemented