addFoundSetFilterParam question

Classic Servoy
1

Hi,
I need to restrict a foundset using addFoundSetFilterParam but it is on 2 different data providers.

eg.
show all records when dataproviderA = 1 and dataproviderB != 2

Should that be possible?

controller.addFoundSetFilterParam('on_wip', '=', '1')
controller.addFoundSetFilterParam('wip_show_invoicing', [b]'!='[/b], '2')
controller.loadAllRecords()
foundset.clear()
2

that should work fine, these are all the operators you can use:

“=”,
“>”,
“<”,
“>=”,
“<=”,
“!=”,
“in”,
“like”,
“not in”,
“not like”,
“between”,
“not between”,
“is null”,
“is not null”