I’m attempting to run a query on the Salesforce Campaign object. I’m wanting to return all rows where the ParentID field (Reference Field) is blank, null, empty, whatever.
I’ve tried:
Code: Select all
Campaign.ParentID= ‘’
Code: Select all
Campaign.ParentID= Null
Code: Select all
(Campaign.ParentID= ‘’ OR Campaign.ParentID= Null)
Both methods return no rows, even though rows exist where the ParentID is blank. What other options can I try?
Thanks.
Chris