Servoy Forum

I'm using the addFoundSetFilterParam in the onLoad event so that filters the so that the data displayed is only some records.

foundset.addFoundsetFilterParam("table_id", ">",1234

The form opens fine the first time, when I go back to that form later the data is empty.
I'm sure the resolution would be to put the filer someplace else, I'm just not sure where?

Thanks,
Bob

Hi Bob,

pls have a look here:
https://wiki.servoy.com/display/public/DOCS/JSFoundSet#JSFoundSet-addFoundSetFilterParam(dataprovider,operator,value)

Add a filter parameter that is permanent per user session to limit a specified foundset of records. Use clear() or loadAllRecords() to make the filter effective. Multiple filters can be added to the same dataprovider, they will all be applied.

So I wouldn't place that in the onLoad, but rather do that upfront, then call clear() / loadAllRecords(), then goto the form.

Thank you once again Marc!
Bob

We use foundsetFilterParam a lot and found it very powerful. We call it right after the user logged in in our onOpen() method.
There should be an index on the field that it filters to speed things up.

One has to hold in mind that directSQL still can access the data.
It is not a good idea to use the "IN array" construct when the array is very large, that slows down the app very much.
But using "ID IN select-expression" is very fast when the select works on an indexed field.