I’m currently working on filtering a large list of upcoming plans, so that when a plan is associated with a community it only shows plans for the communities of which the user is a member.
To accomplish this, I’m unsuccessfully doing the following:
Current Plans > Communities > Members
Contains
Logged in User
Though there are more filters in play (including both AND and OR filters) when this filter is removed, the plan is visible. But when it’s added, the plan that should be visible to a Community Member user never appears.
So: Is this type of filter problematic? Any recommendations or thoughts?
Here are a some images showing the filter selections. Thanks!
It does seem (at least in this case) that many-to-many relationships are problematic. After revisiting the purpose of the linkage, the center node (i.e. “Communities”, a “many” relationship) was changed to a “one” (i.e. “Community”) relationship and now works.
So, though it’s tempting to have an overly-accommodating many-to-many relationship, the use case still holds when a many-to-one, one-to-many approach is taken:
