Forum Discussion

Silko's avatar
Silko
Icon for Helper II rankHelper II
10 years ago

Tags in a slicer (AND, OR)

Hi,   I have a problem with filtering my data. I have a table of tags which is connected with products, customers, etc. I want to filter my data by tags.   I made a slicer and put the tags as a v...
Need Help
MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
10 years ago

If the tags come from a single column - I assume they do - then AND doesn't make any sense. Each row can only have one. If your tags come from multiple columns, then how are you doing this?

Silko's avatar
Silko
Icon for Helper II rankHelper II
10 years ago

Tags are in a separate table which has a connection table with every table tags are connected to. It is a many to many connection. So for the products I have three tables:
- products table
- tags table
- products_has_tags table

products_has_tags has two columns:
- tag_id - which is connected to ID in tags table
- product_id - which is connected to ID in products table

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Silko we have same situation too, were you able to solve this issue?