# addFoundSetFilterParam and /or binding

**URL:** <https://forum.servoy.com/t/addfoundsetfilterparam-and-or-binding/13382>\
**Category:** Classic Servoy\
**Created:** [December 30, 2010, 7:48am UTC](https://forum.servoy.com/t/addfoundsetfilterparam-and-or-binding/13382 "2010-12-30T07:48:05Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![ttmgybta](https://avatars.discourse-cdn.com/v4/letter/t/3e96dc/32.png) [@ttmgybta](https://forum.servoy.com/u/ttmgybta)\
**Post date:** [December 30, 2010, 7:48am UTC](https://forum.servoy.com/t/addfoundsetfilterparam-and-or-binding/13382/1 "2010-12-30T07:48:05Z")

</div>

Hi

Do I add more than one FilterParam to a foundset, they are “ore” bind.  
How do force an “and” binding, between two or more FilterParam?

Regards  
ttmgybta

---

<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:** [January 4, 2011, 7:31am UTC](https://forum.servoy.com/t/addfoundsetfilterparam-and-or-binding/13382/2 "2011-01-04T07:31:49Z")

</div>

ttmgybta,

Foundset-filters are AND-ed, not OR-ed.

Rob

---

<div class="post-metadata">

**Author:** ![ttmgybta](https://avatars.discourse-cdn.com/v4/letter/t/3e96dc/32.png) [@ttmgybta](https://forum.servoy.com/u/ttmgybta)\
**Post date:** [January 4, 2011, 7:43am UTC](https://forum.servoy.com/t/addfoundsetfilterparam-and-or-binding/13382/3 "2011-01-04T07:43:41Z")

</div>

Rob

I made a different experience.  
Bud if you say so, I have to test it again.

Thanks  
ttmgybta

---

<div class="post-metadata">

**Author:** ![ttmgybta](https://avatars.discourse-cdn.com/v4/letter/t/3e96dc/32.png) [@ttmgybta](https://forum.servoy.com/u/ttmgybta)\
**Post date:** [February 9, 2011, 9:07am UTC](https://forum.servoy.com/t/addfoundsetfilterparam-and-or-binding/13382/4 "2011-02-09T09:07:36Z")

</div>

OK, my mistake!  
I tested again and I saw now that it is “and” bind.  
Sorry…  
Bud of course now my question is how I do “or” bind a addFoundSetFilterParam?

Regards  
ttmgybta

---

<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:** [February 14, 2011, 8:43am UTC](https://forum.servoy.com/t/addfoundsetfilterparam-and-or-binding/13382/5 "2011-02-14T08:43:04Z")

</div>

ttmgybta,

You can the ‘in’ operator to OR over a number of fixed values.

We also have support for the or-null-modifier ‘^||’ in the operator argument:

foundset.addFoundSetFilterParam(‘mycol’,‘^||=’,5)

translates to ‘where mycol is null or mycol = 5’

Rob