I have users with a "field_org" entity reference (multiple values allowed) to the "Org" content type. I also have a "field_org" (single value) in my "Article" content type.
When looking at a user profile (let's call this user "UserA"), how do I build a view that gets you "articles from your orgs" (i.e. created by other users that also belong to any of UserA's orgs)? And, bonus question: how do I exclude articles created by UserA? (since I have a separate "your articles" view showing in the same page).
I know this is probably a combination of relationships and contextual filters, but I can't figure out exactly how to configure them. Probably something like this:
- Contextual filter on node author to prevent "UserA's articles" from showing (set to "exclude" in the options)
- Contextual filter on node author, but probably set to one of the relationships below.
- Relationship between article nodes and orgs?
- Relationship between orgs and users?
Both contextual filters would load the same user ID using "Provide default value".