is there any possibility to pass the in condition in Aqua API
As part of our requirement we need to get multiple subscriptions from the subscription table using Aqua API. Is there any option to pass multiple subscription ids as an input and get the subscription info for that subscription ids,
Typically we can achieve that using IN operation in normal sql. Trying to find some function to achieve that or any other alternate web services to achieve our functionality
Re: is there any possibility to pass the in condition in Aqua API
There is no 'in' operator in Export ZOQL but it does support an 'or' operator, so you could go something like:
select id, name
where id = 'abc123' or id = 'abc124' or id = 'abd125'
Definitely not as clean as the 'in' but hopefully get the job done.
More details here: