I'm attempting to pass a parameter into a Query Database Smart Service node.

I'm attempting to pass a parameter into a Query Database Smart Service node. I'm attempting to query our Oracle Data Store using a pre-defined data source. The query works fine when I hard-code a value into the query so I know my SQL syntax is correct.

The query is as follows:
select "id", "date", "approved", "available", "location", "datetexttest", "expedited", "assignedarb", "arbid", "arbname" from "arbitdates" where "available" = 1 and "approved" = 1 and "arbid" = ac!selectedArbId and "expedited" = ac!expeditedvalue

The passed values is the ac!expeditedvalue and ac!selectedArbId. I've created an input value of this name and set the value to the process variable I'd like to use. However, when I do this the query returns a null value in all the output fields. Am I doing this correctly?...

OriginalPostID-71270

OriginalPostID-71270