Question on foundsetfilters

Classic Servoy
1

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,

2

Hi Hans,

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

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