Skip to Content
0
Sep 21, 2019 at 01:00 AM

Pass multiple values to where condition in query

1785 Views

2019-09-20-20-59-47-sombdsqasci-remote-desktop-con.pngHi Guys,

I am going to pass a parameter with multiple values from global variable to "WHERE" condition in "query" like

WHERE "CLIENT" in $G_CLIENT

Below is the variable input while execute the job.

$G_Client='\'100\',\'200\'' (Select all data from both client 100 and 200)

But, condition does not work. Can anyone tell me the right way to achieve it?

Thanks