function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
hawkeye21hawkeye21 

Query where field equals null

How do you run a query using the Connector where a field equals null?  I feel like I've tried every keyword I can think of and I keep getting no results or an error...

 

I want to pull in data where the Mailing Country on a contact is blank/null.

Best Answer chosen by Admin (Salesforce Developers) 
dreyesdreyes

Be certain the field you include in your query can contain a null value.  Check box for example contains either true or fale or in other words a 1 or 0.

 

However, you can query on a null value:

 

Select a field (in conjuction with above comments)

make the operand "equals"

press Add to query

 

Done