Query Database Smart Service

Is it like you want the query to be run with dynamic values for A & B and at the same time don't want to accomplish this using MNI's

@jurim for your scenario for updating the multiple columns you can use store procedures,
for example
create procedure
[procedure name]
( input1 IN,input2 IN)

BEGIN,

UPDATE TABLE1 SET COLUMN1=1 WHERE COLUMN2 IN (input1,input2);
COMMIT;
END;
and execute this by using executestoredprocedure function
hope this is helpfull

@Jurim409, I think your A & B values will come form process variables.
You need to convert the array values to single text value using joinarray function.
Joinarray(pv!array,","), map this logic to you ACP (which can be used in sql Query).

example query: SELECT column1 FROM schema.mytableWHERE INSTR(','||ac!value||',', ','||column1||',')>0
Here ACP (ac!value is single type)

Have a look at this news event: https://forum.appian.com/suite/tempo/entry/e-180895

Hi @Jurim409, You can use query database smart service

You can use a appian plugin for this . In that java code you can use simple jdbc code to update the table values.

@Jurim409 ,the solution suggested by @venusaikumarc seems to work perfect, you can give it a try

Hi, I prove to use the solution suggested by @venusaikumarc and it works.
Thanks for all your suggestions.