I am running a simple query where I want to get multiple values from db. s

You can not use In operator in Query DB Node in Appian.Instead of In you can go for INSTR function.
select x from pushgrouptable where instr(','||ac!jiraId||',', ','||jiraId||',')>0 . To Pass the parameters you can use.-- joinarray({"PPCQV1","PPCQV2"},",")

Is there any documentation on instr? where can I find it. If my string is PPCQV-1,PPCQV-2,PPCQV-3 CAN i use where instr(','||ac!jiraid)> 0 ?

NM found it online will try it out.

1. That's the correct sytntax, I just tested and works for me (see attached sxreenshot).
2. Does the node fail or it completes but doesn't return anything?
3. Can you attach a set of screenshots showing how this node is configured and the behavior you see when it runs?

Sorry for the duplicate post. I should have refreshed it to see someone had already answered.

The node is not failing but there is no output. So is in supposed to work or not?

appianquery.docx

My example uses hard-coded values, if your values are dynamic and come from a process variable then you have to use the approach that the other user explained (e.g.using instr)

Here's another discussion about the same topic forum.appian.com/.../e-42987

Just tested that approach and worked perfectly. Attaching it for your reference. In my case I didn't need a CAST since my column was already of type text.

Hi Edurado,
I have used the above syntax but getting the error message as "The SQL Query is invalid, com.microsoft.sqlserver.jdbc.SQLServerException: Incorrect syntax near the keyword \\'FROM\\'."
My query looks like below.
select columnname from table where instr(ac!id,concat("|",columnname,"|"))>0 .
please provide your suggestions