find null in rest Console

General
1

I am using the rest console to try to find an object which has one of its attributes (a relation to other table) defined as null. But i can’t find the right syntax.

Table A
|Name|RelationToB|

Where> RelationToB= null --> doesn’t work

2

Hi Nicolas,

I just tried and I see you can search for related items which are not null using the following query:

RelationToB.objectId != null

But I could not find a way to do the opposite. I will discuss with the dev team and we will look into adding that capability.

Regards,
Mark

3

Hi Nicolas,

Please, try with query:
Where> RelationToB IS null.

Regards,
Kate.

4

Worked like a charm, thank you for quick reply guys!