Forum Discussion
Filter up to three genera
Hi, Syndicate_Admin
Not quite understand what you mean. Are you referring to a slicer with hierarchies?
Can you give a specific example to illustrate?
Best Regards,
Community Support Team _ Eason
Hello thank you for your reply. I wouldn't know how to tell you why I'm new to this world and what you mean by a "cutter with hierarchies". As I mentioned, I have a sample database, which contains movie titles. Each record contains one, two or even three genera. An example would be that Row one has in Column 1st Genre, a number 1 that related to the table of Genres, that number is an ID that in the row of the table of Genres, indicates that it is Action. Then in the main table, following the example, row 2 has another different title, with a number 1 in column 1st genre, and a number 4 in column 2nd genre (which by the relationship with the table of genres, the 4 would be drama, then the second title would be of genre Action - drama). I would like to be able to put on the control board, a segmenter with a drop-down list of genres, which, as the user ticks each particular genre, will bring you the titles that meet this condition. But, currently I am analyzing only the first column of genres, how can I make the system analyze up to the 3 possible types of genres that EACH title can have? So, if the user in the segmenter ticks three genres, filter out the titles that meet only those 3 conditions together, not separately (i.e. if they choose action - adventure - comedy, bring only the titles that have action in the 1st genre column, adventure in the 2nd genre column, and comedy in the 3rd genre column). Let me explain?