For administrative purposes I would like to create a view that displays all users with a specific role and the content acces taxonomy terms they have selected. I have created a table view with users and tried all to add all types of relationship but I can't seem to select the relationship to the taxonomy term that defines the access

View I would like to create:

User Access
User 1 Department A, department B
User 2 Department A
User 3 Department C
CommentFileSizeAuthor
#10 Screenshot from 2025-09-08 13-09-02.png41.07 KBvitaliyb98
#10 Screenshot from 2025-09-08 13-07-39.png31.46 KBvitaliyb98

Issue fork permissions_by_term-3244658

Command icon Show commands

Start within a Git clone of the project using the version control instructions.

Or, if you do not have SSH keys set up on git.drupalcode.org:

About issue forks

Comments

pieterdeg created an issue. See original summary.

pieterdeg’s picture

pieterdeg commented

Did you find how to create this view? Looking for something similar

frankdesign’s picture

frankdesign commented

Anyone figure this out? I'm looking for this ability too.

katrialesser’s picture

katrialesser commented

I really need this ability as well, trying to find a way to add a relationship or something to make this available??

akleinwaechter’s picture

akleinwaechter commented

Same here. I want to make a view with user and there permitted terms for migration purposes. It would be great if the module would get a relationship in views.
See https://www.flocondetoile.fr/blog/add-relationship-view-programmatically...

vitaliyb98 made their first commit to this issue’s fork.

vitaliyb98 changed the visibility of the branch 3244658-support-view to hidden.

vitaliyb98 changed the visibility of the branch 3244658-support-view to active.

vitaliyb98 opened merge request !65

vitaliyb98’s picture

vitaliyb98 commented
StatusFileSize
new Screenshot from 2025-09-08 13-07-39.png31.46 KB
new Screenshot from 2025-09-08 13-09-02.png41.07 KB

Provided basic support for the views:
1. Ability to create a view based on permissions_by_term_user table (Permissions by term: User), with a relationship to taxonomy and user.
2. Ability to create a view based on permissions_by_term_role table (Permissions by term: Role), with a relationship to taxonomy and user.
3. Added relationship from user -> permissions_by_term_user.

View add page

Using this function, you can, for example, create a view with all taxonomy term which has permission by some users:

View example

vitaliyb98’s picture

vitaliyb98 commented
Version: 8.x-2.34 » 3.0.0
Component: Documentation » Code
Status: Active » Needs review
Issue tags: +views
vitaliyb98’s picture

vitaliyb98 commented

In my opinion, this doesn't feel like a fully polished feature yet, at least for now, since it's a bit rough and has limited view functionality. In my case, I'm using it as a patch, but if anyone needs it, or has ideas on what else could be added to support Views, feel free to reach out.

vitaliyb98’s picture

vitaliyb98 commented
Status: Needs review » Closed (won't fix)

Since there hasn’t been any feedback from the community for a year, I don't see a reason to complicate the module’s functionality.

However, if someone needs this feature, they can use the patch. If the feature gets more attention in the future, we can reopen it for consideration.

Now that this issue is closed, review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, credit people who helped resolve this issue.