We have a process that goes through a loop using a query to capture the ids in a

Certified Senior Developer
We have a process that goes through a loop using a query to capture the ids in a table that are then used in a subsequent step. This process needs to be updated to include another variable in this query. The original query used a 'query database' smart service and I change it to a script task that uses a new rule with the a!queryEntity function. When I test the new rule (as an interface rule) with valid data inputs, I get the results I expect, but when testing it in the process model, it doesn't work. I'm getting no errors but the target (rgtrIDsForFile) has no values and it should. I originally had it saved as an interface rule but after reading something in the forum, I changed it to an expression rule. Attached is the expression rule and here's what I have on the script task:

Expression: rule!esc_getRgtrIdsForReceivableDates(pv!receivableDatesForQuery,pv!rgtrAIPCode, pv!ryId_txt).data
is appended to list
Target: rgtrIDsForFile...

esc_getRgtrIdsForRecDates.txt

OriginalPostID-203294

OriginalPostID-203294

  Discussion posts and replies are publicly visible