Celigo Mapping - Dynamic Salesforce Search (lookup)

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

Comments

1 comment
Date Votes
  • 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.

 

Didn't find what you were looking for?

New post