Query for null pointer entries

Parse Server 📡 Cloud Code
#1

I would like to return all results which do not have a pointer set in a pointer column (see image). It’s impossible to query for undefined as it returns all values.

Screenshot 2022-01-07 at 20.56.56
Screenshot 2022-01-07 at 20.56.56802×428 33.7 KB

#2

Tayloruk, if you use the ParseQuery SDK use the relational queries.

Not sure on how to do it using directly the Rest Api

#3

Thanks @cofimate .

I managed to find the right answer by using the $exists key. So the query in this case looks like this:

/?where={"clientId":{"$exists":false}}