Managing addFoundSetFilterParam

Classic Servoy
1

Hello dev team,

We already make a good use of the addFoundSetFilterParam() function, which saves us lots of time. But has the major limitation of being ‘session wide’ lasting.
We would LOVE being able to manage stacked filters or at least being able to delete all filters for the current controller without restarting the solution. :D

Is this doable?

Here are some suggestions:

a) clearFoundsetFilterParam() - which deletes all stacked filters

or

b) popFoundsetFilterParam([n]) - which removes n latest filters

and more difficult,

c) duplicateFoundsetFilterParam - which would be used similary to the current duplicateFoundset() function

To know how much we will want these functions, simply remember the cat in shreck 2 ( :shock: ), :wink:

2

Does my request make sense?

Or anybody knows a workaround? (Other than direct SQL procedures)

3

will look if we can make it changeable after 2.1.1

4

Some news about these features?

5

I’d prefer this version: Pledge for more power to the developer :) - Classic Servoy - Servoy Community

6

How about having both implemented, Patrick?

Managing addFoundSetFilterParam() will be easy to use for all developpers. Your approach is more ‘power user’ oriented.

7

I think it is actually easier using SQL. SQL is something that even the underpowered Servoy developer will sooner or later come across. And here we are talking about just the WHERE-clause, not sophisticated subquery stuff. Personally, I find it easier using SQL than learning the addFoundSetFilterParam-language to describe just that, a WHERE-clause, just with less possibilities…

8

won’t happen for 2.2. This is on a feature freeze currently. Will look after that.