Consider my scenario.
So i have query something like this.
id from user where user_name in (**user_list**) and user_status='Active'
select * from payment where payment_status=1 and payment_user in (select id from userdata)
select order.id from order, payment where order.paymentid=payment.id and order.orderstatus=1
In above query, i have a user_list(marked in bold) is a list of users which i want to pass at a runtime.
Above is query to make a view.
So i want that user_list should be a variable and the list of users(which will be array of string values) i will pass at runtime.
Note: users is a list usernames and which is array of string values like 'Tom','John'
So how can i achieve this. I want to expose it as REST API and i will pass user_list to that api endpoint.