Filtering Items based on a linked Data Type's Field

[Justin18]

Hello!

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.

Thanks!

[Zeroic]

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

[Justin18]

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.

[Zeroic]

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

[Justin18]

Thanks so much, that solved it!