Where empty string or Null
Posted: Mon 29 Jun 2020 15:36
Hello. Using Devart.Data.Salesforce 3.5.980.0 in VS 2017.
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: and also tried and also tried
Both methods return no rows, even though rows exist where the ParentID is blank. What other options can I try?
Thanks.
Chris
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