i dont understand this well enough to know why this isn’t working. i have a movie database and i need to restrict or filter certain content for some users.
here’s an example of the UI to illustrate what i want to achieve:
there’s 2 filter options and you chose whether to filter the RG by a specific genre(s) or catalogue(s) or exclude specific genre(s) or catalogue(s). or any other variation including just using one option and leaving one blank.
the database structure is as follows, 4 datatypes:
Metadata
Genres
Catalogues
Users
in the Metadata datatype i have 2 fields:
Genre ID which is List of Genres’s
Catalogue ID list which is List of Catalogues’s
i’m saving these filter options in the User datatype as follows:
for the filtering portion, i found these work individually (catalogue versions are the same):
but when i tried combining them all as follows, the RG just goes blank and doesn’t show anything
i can’t see a way to account for all the possibilities for example:
catalogue filter - filter
genre filter - filter
catalogue filter - exclude
genre filter - filter
catalogue filter - blank
genre filter - exclude
I’ve already checked privacy settings and nothing is causing an issue, also no other conditionals etc are interfering.
or am i approaching this completely wrong and there’s a far simpler way to achieve this?