search table by multiple properties

Is there a way to search a table by more than one property? I have a table Latency and I would like to search by requestId, locationId, and carrierId. I have tried


and even


using SQL Search, which is probably wrong.

They all result in:

{"code":1025,"message":"Invalid data query parameter: locationId"}

If it’s not possible, I can use sortBy with where, but the ability to search by multiple properties would make things much faster and easier. Thanks!

Hello, Eric!

Try using AND instead of &. So, the clause would look like “requestId=‘12345’%20AND%20locationId=‘1’”

best regards,

Awesome. Thanks Alex.