I am really confused on the AND OR filters in a query list. As an example I want to filter a list if:
The student must be a Senior (her grade) AND must be female (her gender)
There sports preference can be soccer OR swimming OR rugby
I tried doing the below in the Query List but it essentially retuned the whole list; it did not filter.
Grade = Senior
Gender = Female