Filtering Items based on a linked Data Type's Field

Justin18 · 2024-07-30T16:20:43.585Z

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!

Screenshot 2024-07-30 091831

Zeroic · 2024-07-30T16:30:53.142Z

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 · 2024-07-30T16:34:19.000Z

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 · 2024-07-30T17:06:18.391Z

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 · 2024-07-30T20:35:48.665Z

Thanks so much, that solved it!

system · 2024-10-08T16:20:56.768Z

This topic was automatically closed after 70 days. New replies are no longer allowed.