I am passing an activity class to a Query Database Smart Service and am receivin

I am passing an activity class to a Query Database Smart Service and am receiving the following error: There was a problem executing the SQL query: SQL Message: ORA-01722: invalid number. I am using the “IN” operator to update multiple values. When I hard code the values for 'ac!IDs' the query executes perfectly. However when I try to pass in values from an Integer PV of type multiple I receive this error message. I have searched the forum and have tried a few different solutions including joinArray() that converts the integer of type multiple into a single text string.
Current Configuration -
SQL Statement: UPDATE PVCR_CASE SET STATUS = ac!status WHERE CASEID IN(ac!IDs)
ac!IDs: text that is not of type multiple. Formula: =joinarray(pv!selectedCaseIDs ,",")
The field we are searching in the database is of type Integer.
Any assistance would be much appreciated!

OriginalPostID-180895

OriginalPostID-180895

  Discussion posts and replies are publicly visible

Parents Reply Children