Thank you, I've changed it to
That resolved the MySQL but I'm still unable to filter as I had hoped - I suspect I'm not setting it up/using it in the correct manner though.
Is it possible to use the relation fields to filter items within a category based on their association to their related item?
E.g. I have the below structure of schools and courses:
Items of type '
School' and in category '
Schools':
- School 1
- School 2
Items of type '
Course' and in category '
Courses':
- Course 1
- Course 2
- Course 3
I have a relation field of
'Course School' which selects from the list of items in
School category + type and is assigned to the
Course type. So when on a course page you see the school that the course sits within.
I have a reverse-relation field of '
School Courses' which is assigned to the
School type, so when on a 'School' page you see the list of courses for that school.
I haven't enabled use 'locked' filters as I want the users to be able to select the school to filter the list of courses.
I've attached a screenshot to try and show what's currently happening.