using addFoundSetFilterParam to OR two dataproviders

[acho-bacho]

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

[rgansevles]

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

[mboegem]

use the 'IN' operator:

Code: Select all

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