- Let's assume the report pulls a list of classes
Filters are: Class Level and Class Location (filter type is select/drop-down)
Use case: If user selects "Beginner" in the Class Level filter, refresh the page (easy to do with this.form.submit() in the 'Onchange event' field in the filter), and narrow down the Class Location filter LOV's (list of values) to only those locations that have Beginner classes.
Dynamic filter LOV based on other filter selection
Forum rules
This forum is not for any support questions/issues/features. Please use Support Center for such requests.
This forum is not for any support questions/issues/features. Please use Support Center for such requests.
-
- Posts: 1
- Joined: March 4th, 2016, 6:54 pm
- Name: Pavel Dolezel
Dynamic filter LOV based on other filter selection
Hi, is it possible for the Values SQL query in a filter to have a WHERE statement with input from another filter. E.g.:
-
- Site Admin
- Posts: 976
- Joined: October 21st, 2008, 5:39 pm
- Name: Administrator
- Browser: Chrome
Re: Dynamic filter LOV based on other filter selection
Yes, it's possible.