batonac
Member
Please forgive me if this is covered elsewhere in the forum and/or documentation...
I'd like to do some advanced databasejoin filtering which I'll use a hypothetical scenario to describe:
I've already discussed a scenario where two tables, 'student' and 'class' are many-to-many joined by a third table: 'student_has_class'.
Now I'd like to filter the join list in the fabrik form so that only certain classes are available to be assigned to students. Let's say there's a third table called 'study_track' and both the 'student' table and 'class' table contain a 'study_track_id' field/element. How do I filter the 'student_has_class' databasejoin so that only classes with the same 'study_track_id' are available?
Also, if we take this a step further, and create a many-to-many join between 'class' and 'study_track' using a table called 'study_track_has_class', how can we create the same filter as above based on that join?
I'd like to do some advanced databasejoin filtering which I'll use a hypothetical scenario to describe:
I've already discussed a scenario where two tables, 'student' and 'class' are many-to-many joined by a third table: 'student_has_class'.
Now I'd like to filter the join list in the fabrik form so that only certain classes are available to be assigned to students. Let's say there's a third table called 'study_track' and both the 'student' table and 'class' table contain a 'study_track_id' field/element. How do I filter the 'student_has_class' databasejoin so that only classes with the same 'study_track_id' are available?
Also, if we take this a step further, and create a many-to-many join between 'class' and 'study_track' using a table called 'study_track_has_class', how can we create the same filter as above based on that join?