# Using addFoundSetFilterParam with IN operator

**URL:** <https://forum.servoy.com/t/using-addfoundsetfilterparam-with-in-operator/8208>\
**Category:** Classic Servoy\
**Created:** [October 5, 2007, 12:16pm UTC](https://forum.servoy.com/t/using-addfoundsetfilterparam-with-in-operator/8208 "2007-10-05T12:16:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![martinh](https://avatars.discourse-cdn.com/v4/letter/m/848f3c/32.png) [@martinh](https://forum.servoy.com/u/martinh)\
**Post date:** [October 5, 2007, 12:16pm UTC](https://forum.servoy.com/t/using-addfoundsetfilterparam-with-in-operator/8208/1 "2007-10-05T12:16:14Z")

</div>

Hello,

I need to use a addFoundSetFilterParam on my foundset using the IN operator. The documentation says that this is possible, but it doesn’t work.

I need a filter on orderstatus where orderstatus = D or I  
The following syntax I tried, also with quotes around D and I,  
but none of these seem to work.

```auto
_foundset.addFoundSetFilterParam('salesorder_status', 'IN', '(D, I)');

```

also

```auto
_foundset.addFoundSetFilterParam('salesorder_status', 'IN', 'D, I');

```

doesn’t work good, but it returns the records with only status D

Anyone knows the exact syntax for using IN operator?

---

<div class="post-metadata">

**Author:** ![Joas](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/joas/32/5095_2.png) [@Joas](https://forum.servoy.com/u/Joas)\
**Post date:** [October 5, 2007, 12:31pm UTC](https://forum.servoy.com/t/using-addfoundsetfilterparam-with-in-operator/8208/2 "2007-10-05T12:31:34Z")

</div>

You should use an array containing your values:

```auto
_foundset.addFoundSetFilterParam('salesorder_status', 'IN', new Array('D', 'I'));

```

---

<div class="post-metadata">

**Author:** ![martinh](https://avatars.discourse-cdn.com/v4/letter/m/848f3c/32.png) [@martinh](https://forum.servoy.com/u/martinh)\
**Post date:** [October 5, 2007, 12:35pm UTC](https://forum.servoy.com/t/using-addfoundsetfilterparam-with-in-operator/8208/3 "2007-10-05T12:35:50Z")

</div>

Perfect! That works

---

<div class="post-metadata">

**Author:** ![pbakker](https://avatars.discourse-cdn.com/v4/letter/p/a4c791/32.png) [@pbakker](https://forum.servoy.com/u/pbakker)\
**Post date:** [October 5, 2007, 12:47pm UTC](https://forum.servoy.com/t/using-addfoundsetfilterparam-with-in-operator/8208/4 "2007-10-05T12:47:43Z")

</div>

In such scenario’s, you can always check the exact queries fired at the database through the admin pages (performance log).

that will give you a good ide what is going on.

Paul