using addFoundSetFilterParam to OR two dataproviders

Classic Servoy
1

Hi all,

how can I use addFoundSetFilterParam() to filter two different dataproviders using OR.
For example if I have a table called ‘car’ with fields ‘make’ and ‘color’
I would want to filter the foundset as: filter all cars that are Renault or cars that are RED

How do I do that?
foundset.addFoundSetFilterParam(‘make’, ‘=’, ‘Renault’)
OR
foundset.addFoundSetFilterParam(‘color’, ‘=’, ‘RED’)

PS - do not buy a Renault

2

acho-bacho,

This is not supported, foundset-filters are always ANDed.

You can OR conditions using find/search or query builder, but these are not placed in the filter.

Rob

3

use the ‘IN’ operator:

foundset.addFoundSetFilterParam('id', 'IN', "SELECT id FROM car WHERE make = 'renault' OR colour = 'red' ")