I’m trying to figure out how to filter items based on a field that is contained within a separate but linked datatype. I have “developments” and I have “cases” as the data types. The cases are tagged to the developments, and within the cases I have the field “Selected Focus” which is categorized as either “focus” or “pending” which corresponds to how important the case is currently.
I want to have a repeating group display all the developments for cases that are within the “focus” category.
I’m having no luck doing a constraint that the Case tag needs to contain a search for cases with the tag of “Focus” since it returns an entire list of cases.
Hi! You can use the is in instead of contains operator. That way you can specify the list of cases.
Since the Case tag is (I’m assuming) not a list, the contains wouldn’t make much sense since a single element can’t contain a list. Instead a single element can be in a list
Thanks for the reply! The Case tag is actually a list since a development can be tagged to multiple Cases. So unfortunately, “is in” does not appear to be an option.
Ah okay! Then you should ideally use the intersect with operator. It will be available in the Advanced filter. I generally use this as a last resort (in case the DB can’t be optimized further) since it could become heavy WU-wise as the app scales
