I’m stuck with filtering a list and I am trying to figure out whether I’m doing something wrong or if it’s just not possible with a many-to-many relationship (since I have it working with a one-to-many).
Let’s say I have three tables:
Items
Ratings
Tags
When people leave a rating for an item, they can add one or more tags to that rating.
I want to let visitors browse items based on tags added to ratings. I set this up by showing a chip list of all tags (that works). Then, I want someone to tap a chip to see a list of items (not ratings) associated with that tag. I have it working with a similar field that doesn’t have a many-to-many (imagine - each rating could have one location) but not with this one so I’m wondering if that’s what it is.
A workaround I could imagine is setting a filtering field equal to the text of all the tags put together, and searching that.