Query IN Clause with parameter

Question

Here is my query,

<Request method="GET">
   <Query>
     select user_id from user
     where user_type in ($userTypes)
   </Query>
</Request>

How do I sent multiple values for this parameter $userType in metamug resource file. I'm using a GET request. And my database is postgres.

$userTypes is list of ids. I can pass it as comma separated string "1501,1502,1503" in the request.

Thanks.

Answer 1

You could use:

select user_id from user
where user_type in (SELECT unnest(string_to_array($userTypes, ',')));

DbFiddle Demo

Answer 2

you can also write it as

<Request method="GET">
   <Query>
     select user_id from user 
     where user_type =any(string_to_array($userTypes,',')::int[]);
   </Query>
</Request>

I've typecast it as Integer array you can use any other datatype as per your need.