Cascade Filters

Get Help
1

Hi!

I want to know if it's possible to link filters when the values in dropdown I am showing is from a Model.

Example: I have teachers table and a students table.

Multiple students allotted to one teacher, but only one teacher is allotted to a student.

I want to show the list of subjects the teacher-student combination has:

For that I am showing one dropdown for teachers, another dropdown for students, this students dropdown contains all the students as I am taking it from the Model list. But how to show the students only under the particular teacher?

I can't use table directly, using model list is mandatory for me.

Please help.

2

That's supported. What's not working?

3

How can I filter Model List based on the previous dropdown selection?

4

This is standard functionality:

5

it won't work if you are referencing a model because of column aliasing, linked filters only work with tables

6

It works for me.

7

It works only if the model columns are connected to database columns

8

what do you mean? how to do that?

9

I have a model based on sql and when I add a filter i get this

image
image1445×657 10.3 KB