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
troubles1troubles1 

null search in Connector

Need some help defining the correct syntax to search for an unpopulated fields in SFDC utilizing the connector.  Specific need is "show me accounts where the ParentID reference field is blank", but other null or empty searches are on the horizon. 

 

Is there a specific method to search for null/empty.  Is the format field specific?  ("") doesn't seem to work in my example above nor does the word null.

Thanks

troubles1troubles1
nevermind. . . sorry for the request.  found the associated post in this board!
Ron HessRon Hess

Yes, you must have discovered that an empty cell will be translated to an empty string when constructing the SOQL statement, unless it's a date field, in which case there is a 'null' passed into SOQL.

look for this to appear in the FAQ sometime soon.