# Foundset find mode equivalent of NOT IN (...)

**URL:** <https://forum.servoy.com/t/foundset-find-mode-equivalent-of-not-in/19672>\
**Category:** Classic Servoy\
**Created:** [May 1, 2018, 7:02am UTC](https://forum.servoy.com/t/foundset-find-mode-equivalent-of-not-in/19672 "2018-05-01T07:02:51Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![steve1376656734](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/steve1376656734/32/4613_2.png) [@steve1376656734](https://forum.servoy.com/u/steve1376656734)\
**Post date:** [May 1, 2018, 7:02am UTC](https://forum.servoy.com/t/foundset-find-mode-equivalent-of-not-in/19672/1 "2018-05-01T07:02:51Z")

</div>

Hi,

Using a foundset in find mode I can search for records which have a field with values that are in an array by using:

```auto
foundset.find();
foundset.myField = ['value1', 'value2', 'value3', ...];
foundset.search();

```

What is the equivalent code for finding records whose value is NOT IN the array i.e. WHERE myTable.myField NOT IN (‘value1’, ‘value2’, ‘value3’, …)?

I would normally do this sort of thing using Query Builder as it has much more control over finding records, but in this particular scenario one of the criteria that I am using in the search (not the array based one) is a calculation and I can’t find a way to include calculations in a Query Builder select statement.

A solution to either scenario (find mode NOT IN or Query Builder using calculations) would be most appreciated.

Thanks  
Steve

---

<div class="post-metadata">

**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\
**Post date:** [May 11, 2018, 9:08am UTC](https://forum.servoy.com/t/foundset-find-mode-equivalent-of-not-in/19672/2 "2018-05-11T09:08:53Z")

</div>

> steve1376656734:  
> one of the criteria that I am using in the search (not the array based one) is a calculation and I can’t find a way to include calculations in a Query Builder select statement

Steve,

Search using find mode ends up doing a query in the database as well, for this reason non-stored calculations are not supported in find mode.  
If the calculation is stored (so it is also a db column) you can use it icw the QueryBuilder.

Rob