# Celigo Mapping - Dynamic Salesforce Search (lookup)

**URL:** <https://connective.celigo.com/t/celigo-mapping-dynamic-salesforce-search-lookup/723>\
**Category:** Integration Apps\
**Tags:** sql, filter, lookup, salesforce, netsuite\
**Created:** [July 1, 2022, 5:09am UTC](https://connective.celigo.com/t/celigo-mapping-dynamic-salesforce-search-lookup/723 "2022-07-01T05:09:13Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![skiesolutions](https://avatars.discourse-cdn.com/v4/letter/s/49beb7/32.png) [@skiesolutions](https://connective.celigo.com/u/skiesolutions)\
**Post date:** [July 1, 2022, 5:09am UTC](https://connective.celigo.com/t/celigo-mapping-dynamic-salesforce-search-lookup/723/1 "2022-07-01T05:09:13Z")

</div>

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:

![5301043caa20740200000001-f1af4d01971f4d5381bf4e3afe7de5b5.png](https://us1.discourse-cdn.com/flex001/uploads/celigo/original/2X/e/eb2db50af1bf1694b936e5d4b0707c13ac8bf2fa.png)

(it's 2x single quote sign ')

SQL representation: (Netsuite\_Internal\_Id\_\_c != '')

Is this syntax correct?

---

<div class="post-metadata">

**Author:** ![muneswarathotakura](https://avatars.discourse-cdn.com/v4/letter/m/e480ec/32.png) [@muneswarathotakura](https://connective.celigo.com/u/muneswarathotakura)\
**Post date:** [July 1, 2022, 8:52am UTC](https://connective.celigo.com/t/celigo-mapping-dynamic-salesforce-search-lookup/723/2 "2022-07-01T08:52:47Z")

</div>

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.