I want to list all the users and groups they are member of in one table, one row per user.

I have a simple view that lists all users in the system. I added relation to group content membership and a "Parent group" field to the view.

I tried aggregation, but no luck.

Lets say we have 3 users (user1, user2 and, user3) and 3 groups (Interest1, Interest2, and Interest3). user1 is not a member of any group; user2 is member of Interest1; user3 is member of Interest1 and Interest2.

What I want to see is the following.

Users Interests
user2 Interest1
user3 Interest1, Interest2

What I get is instead this.

Users Interests
user2 Interest1
user3 Interest1
user3 Interest2

I also don't see multiple configuration ("Multiple field settings") or something similar in the group field settings.

  • You need to aggregate the group field.
    – Jaypan
    Commented Nov 17, 2022 at 17:51
  • Hello, I already tried it. But that did not work. It still showed the two rows when I activated the aggregate function.
    – carlo
    Commented Nov 18, 2022 at 8:48
  • for now I solved using views_field_view with contextual filter
    – carlo
    Commented Nov 18, 2022 at 14:35
  • You need to clarify how the users are related to groups, what types of references are they, are users connected to groups directly, or indirectly through group content, what is a parent group, what field did you set the Aggregation to which option?
    – prkos
    Commented Dec 31, 2022 at 1:46


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Browse other questions tagged or ask your own question.