Closed
Read and write pre-filter settings
- Sidekick
- 123 replies
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?
+5Hi Edwin,
You could have your prefilter always enabled but not performing any filtering unless the filter setting is present.
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)
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.