"WHERE" condition in get request

I do a request
/api/v1/Product?maxSize=100&offset=0&sortBy=type&asc=false&where%5B0%5D%5Btype%5D=greaterThan&where%5B0%5D%5Battribute%5D=modifiedAt&where%5B0%5D%5Bvalue%5D=2019-09-28
Also products have field ‘status’ and I want to query only products with statuses ‘published’ and ‘discontinued’. Can I avoid post processing and write my request somehow to avoid products with another statuses in response? I already have one ‘where’ condition in my request, can I add another one?

Hi Yulia,
yes, you can add the „where“ condition and query only products with needed statuses. Then you will have the following request:
/api/v1/Product?maxSize=100&offset=0&sortBy=type&asc=false&where%5B0%5D%5Btype%5D=greaterThan&where%5B0%5D%5Battribute%5D=modifiedAt&where%5B0%5D%5Bvalue%5D=2019-10-01&where%5B1%5D%5Btype%5D=in&where%5B1%5D%5Battribute%5D=status&where%5B1%5D%5Bvalue%5D%5B%5D=published&where%5B1%5D%5Bvalue%5D%5B%5D=discontinued