How to search for multiple records

Data Service
1

Does the WHERE clause for retrieving data objects support the SQL “WHERE <column name> IN (value1, value2, value3)” or do we need to specify it like WHERE column=value1 OR column=value2 OR column=value3 etc.?

2

Hi, Simon!

Yes, IN operator supported in data service.
Example:

curl
-H application-id:application-id-value-from-console
-H secret-key:secret-key-value-from-console
-X GET
-v [url=https://api.backendless.com/v1/data/Person?where=age+in+('30','50','55')]https://api.backendless.com/v1/data/Person?where=age+in+('30','50','55')[/url]

Regards,
Kate

3

Thanks!