Celigo Mapping - Dynamic Salesforce Search (lookup)

SKIE Solutions

• July 01, 2022 05:09

In my search filters I have to be sure that all empty values for certain field are disregarded.

I would like to have the following criteria in place: Netsuite__Id NOT EQUAL null

Below is the syntax of my current formula:

(it's 2x single quote sign ')

SQL representation: (Netsuite_Internal_Id__c != '')

Is this syntax correct?

0

• 

  Muneswara Thotakura NetSuite Integration Whiz Salesforce Integration Whiz Software Engineer

  • July 01, 2022 08:52

  

  

  Hi SKIE Solutions, 
       Yes it's the right syntax (Netsuite_Internal_Id__c != ''). Please let us know if you face any issues with the above syntax.

  0

Please sign in to leave a comment.