Many to Many Filter Troubleshooting

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!

Screen Shot 2022-06-24 at 12.05.28 PM

Screen Shot 2022-06-24 at 12.47.09 PM

Hi @wes ,

This probably won’t come close to your issue, but I made an example and free template about community, search the forum of Komun.

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:

  • Current Plans > Community > Members
  • Contains
  • Logged in User
1 Like

This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.