Get objects with specific ownerId

Console
1

Hi,

Struggling to find the syntax for an inverted where clause to be used in console.

I would like to filter on objects in a table for which ownerId = ‘XXX’ or, even better, on those for which the owner has a given email address.

I haven’t managed to make sense of Inverted Relation Retrieval - Backendless REST API Documentation
in this particular case.

Thanks for your help.

2

Hi Nicolas,

If you need to get objects where the ownerId column has a specific value, the where clause in the following format should work:

ownerId = 'specific value'

I don’t think this use case requires an inverted version of the where clause.

Regards,
Mark

3

Sure, but what about the case where I want to filter on objects whose owner has email ‘abc@xyz.com’ ?

4

Here’s the query in that case:

ownerId in (Users[email = 'abc@xyz.com'].objectId)
5

Simple…
Thanks for the tip !