Multiple rows returned from the database lookup TABLE action
Multiple return values can be handled from a database run in the database lookup TABLE action. The engine handles multiple values returned in a Tcl list and notifies that multiple values were returned.
Generally, there should be only one row returned in the database lookup TABLE action. If there are multiple rows returned, then the expected field of each row is combined to a list and set to the specific destination’s out column.
For example:
SELECT intFLD,dateFLD,flag FROM Table_sanity WHERE ID=<ID> and strFLD=<strFLD> ORDER BY ID
Rows returned:
test1, 2014-04-01, 0
test2, 2014-04-02, 0
test3, 2014-04-03, 0
Destination out columns:
intFLD is set to {test1 test2 test3}
dateFLD is set to {2014-04-01 2014-04-02 2014-04-03}
flag is set to {0 0 0}