Using TDP workbook 5.05.61, trying to set up a bind variable using the "IN" operator so the user can choose one or more values when they execute the query (see below). When I execute the query, the DED_DESCR field does not come up in the bind variables window, I get zero rows returned and I see this in the SQL statement:
WHERE (ADP_DEDUCTION.DED_DESCR IN (':DED_DESCR'))
Is there a way to get this to work?
The IN operator in the Query Builder was not designed to support a bind value. The IN operator needs a list of values separate by commas. Instead of using the bind value select the drop down arrow. This will load a list of available distinct values. Check the values you want in the IN clause.