I have this statement as the SQL statement on a Query Database node:UPDATE `ThisTable` SET `Status`= ac!closedStatus WHERE `TableId` in (ac!ListOfTableIds)
ac!closedStatus is an Int, ac!ListOfTableIds is a list of ints.
When I run the process, the Query Database node errors with this error: There was a problem executing the SQL query. SQL Message : class [Ljava.lang.Long; cannot be cast to class java.lang.Long ([Ljava.lang.Long; and java.lang.Long are in module java.base of loader 'bootstrap')
I know I've gotten "IN" working on query database before, I just always forget the trick. Does anyone know it?
Discussion posts and replies are publicly visible
Can you try this
UPDATE `ThisTable` SET `Status`= ac!closedStatus WHERE `TableId` INSTR(','||ac!ListOfTableIds||',', ','||TableId||',')>0
ac!ListOfTableIds should be joinarray(pv!ListOfTableIds,",")
For more information, please refer
https://community.appian.com/discussions/f/integrations/1367/i-am-having-issues-using-the-in-operator-of-a-where-clause-in-a-quer