Dynamic filter LOV based on other filter selection

Complete full-featured tool for preview and download of SQL reports in your Joomla site.
Forum rules
This forum is not for any support questions/issues/features. Please use Support Center for such requests.
MtnPavlas
Posts: 1
Joined: March 4th, 2016, 6:54 pm
Name: Pavel Dolezel

Dynamic filter LOV based on other filter selection

Post by MtnPavlas »

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.
Thank you

User avatar
Admin
Site Admin
Site Admin
Posts: 929
Joined: October 21st, 2008, 5:39 pm
Name: Administrator
Browser: Chrome

Re: Dynamic filter LOV based on other filter selection

Post by Admin »

Yes, it's possible.