I’m looking to filter a repeated group on a criteria that is not of the type of the data type of this group - essentially an SQL “where” on another data type.
Basically, my database looks like that : I have a data type “materials”, that has a field “theme” (which is also a data type), and each “theme” has an option set “season” (winter or summer).
I want to create a filter where I only display the “Material” type in my repeated group WHERE the season FOR this material’s theme is the value of my radio button.
What I’ve done so far is a filter “theme = do a search for THEME where SEASON = radiobutton’s value” . But the builder expects another element that is not of the type “value” (note that I have another filter on “theme” above that works well).
I can only choose options such as “count” or “contains” but I just want to display all instances of theme where theme’s season = radiobutton’s value.
Am I missing something here ?
- also, on the theme of advanced filters, I want to use images as inputs, meaning that when someone clicks on the image with the sun, the group filters on “summer” for example. But
a) I can’t find an input where I could add an image and
b) if I were to use an image, since there’s not text, I don’t see how I could “tell” the filter to sort on a text value where an image is selected.
Is that possible ?
Thanks a ton