addFoundSetFilterParam and /or binding

Classic Servoy
1

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

2

ttmgybta,

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

Rob

3

Rob

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

Thanks
ttmgybta

4

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

5

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