Read and write pre-filter settings

Related products: Software Factory

We would like to add a possibility to be able to read the pre-filter setting (on/off) for the prefilters from the templates and would like to be able to set the prefilters on and of from the templates. With this possibility you're able to write a filter setting in a record with a task and you can directly turn the filter on or off depening on the task you run.
Have you looked into the possibility of using process flows?
Hi Edwin,



You could have your prefilter always enabled but not performing any filtering unless the filter setting is present.



code:
not exists(
select 1
from filter_setting f
where f.tsf_user_id = dbo.tsf_user()
)
or exists(
select 1
from filter_setting f
where f.tsf_user_id = dbo.tsf_user()
and f.x = t1.x)