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
Any particular reason you can't use the WTDS node? I avoid the Query DB node at all costs, because it's not user friendly, not flexible, not easily testable...
Hi Mike, just trying to update one field for an array of data types. I am trying to avoid querying all the data and storing it in process to keep process size small and avoid heavy queries
If Record Types are an option, you can do this by simply providing the identifier and field you want to update. All other fields will be ignored. For Data Types, it is possible to do as well, you need to create an additional datatype with the primary key and field you want to update.