I need some help understanding how to evaluate a resultset on a branch step.
using a JDBC Select Adapter to retreive items (resultSet is itemsOutput)
LOOP over ‘/itemsOutput/resultSet’
BRANCH (evaluate = TRUE)
%itemsOutput/resultSet/item_type% = ‘FG’:SEQUENCE (doesn’t work)
%itemsOutput/resultSet/item_type% = ‘FG’:SEQUENCE (does work)
Issue: How do you evaluate on an particular field in a resultSet from a Select statement? Or how do you use a variable to determine the resultSet index? Do you really have to store this field off to another variable to use in the evaluate step?
Any help would be appreciated.