• State Verified Answer
  • +2 person also asked this people also asked this
  • Replies 8 replies
  • Answers 1 answer
  • Subscribers 10 subscribers
  • Views 12039 views
  • Users 0 members are here
Related Discussions
Home » Discussions » Integrations

I am having issues using the "IN" operator of a where clause in a Quer

wendys42
I am having issues using the "IN" operator of a where clause in a Query Node to get data from SQL. An example of my SQL query is: SELECT COUNT(IDColumn) from dbo.TableName WHERE OtherColumn = aValue AND IDColumn IN (ac!varIds)
The data type of the "IDColumn" field is an integer - I have tried passing in a multi-value integer as the input, but I receive the error message: There was a problem executing the SQL query. SQL Message : [Ljava.lang.Long; cannot be cast to java.lang.Long] I have also tried using a string, but I still receive errors. How can I use ac variables with the "IN" operator to get the data? ...

OriginalPostID-85529

OriginalPostID-85529

  Discussion posts and replies are publicly visible

Parents Reply
  • 0 in reply to subhajits

    Yes, it seems that array values are not handled correctly by the Query Database smart service.

    Here is a query that I have used to update a table in MySQL:

    UPDATE `TABLE_NAME` SET  `COLUMN_NAME`= 'new value'  WHERE INSTR(concat(',', ac!IDs, ','), concat(',', `TABLE_NAME`.`ID`, ',')) > 0

    where ac!IDs is TEXT, single type. And ac!IDs is configured as =joinarray(pv!idValueList,",")

    where idValueList is a process variable of type number, multi-valued (for example {100, 200})

Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.