# Question on foundsetfilters

**URL:** <https://forum.servoy.com/t/question-on-foundsetfilters/11975>\
**Category:** Classic Servoy\
**Created:** [March 31, 2010, 7:21pm UTC](https://forum.servoy.com/t/question-on-foundsetfilters/11975 "2010-03-31T19:21:49Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Hans\_Nieuwenhuis](https://avatars.discourse-cdn.com/v4/letter/h/87869e/32.png) [@Hans\_Nieuwenhuis](https://forum.servoy.com/u/Hans_Nieuwenhuis)\
**Post date:** [March 31, 2010, 7:21pm UTC](https://forum.servoy.com/t/question-on-foundsetfilters/11975/1 "2010-03-31T19:21:49Z")

</div>

Hi,

when creating foundsetfilters you add pairs of dataprovider, operator and value.

These result in a query constructed by servoy where these result in a “where columnx = valuex and columny \> valuey” etcetera.

Is there also a way to create a foundsetfilter that has both AND and OR ?

Something like “where columnx = valuex and ( columny \> valuey or columnz != valuez)”

Regards,

---

<div class="post-metadata">

**Author:** ![mboegem](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/mboegem/32/4399_2.png) [@mboegem](https://forum.servoy.com/u/mboegem)\
**Post date:** [March 31, 2010, 7:57pm UTC](https://forum.servoy.com/t/question-on-foundsetfilters/11975/2 "2010-03-31T19:57:41Z")

</div>

Hi Hans,

you can also you use the ‘IN’ operator which you can help to construct what you want:

```auto
var $qry = 'SELECT colname FROM table WHERE (whateveryouwant1 AND whateveryouwant2) OR whateveryouwant3 
var $result = databaseManager.addTableFilterParam( <YOURSERVER>, <YOURTABLE>, <COLNAME>, 'IN', $qry, <FILTERNAME>);

```

Hope this helps