Dynamic filter LOV based on other filter selection
Posted: January 30th, 2020, 5:47 pm
Hi, is it possible for the Values SQL query in a filter to have a WHERE statement with input from another filter. E.g.:
- 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.