Filter Field with LIKE based on another Field
Hopefully someone is able to understand what I'm trying to achieve and help with a solution.
I need to filter based on a "Tag" field with single text values, once selected would filter all relevant items in another dataset that has these tags in a single field "Tags" with multiple text comma delimited "tag1, tag2" for example.
Both created as a new beast mode "=tag_filtering" in both datasets to allow filtering.
Tag - "red" (used to filter)
Tags - "red,small" (needed to filter by)
My thought was a using beast mode something as below but have a feeling I may be well off, especially without having a wildcard % as part of the formula but having no joy, is this possible?
CASE WHEN `tag` LIKE `tags` THEN `GROUP_CONCAT(pt.tag)` END
Any input into the right direction is very much appreciated.