Hello,
I want to create a list of users (in a table format) which are associated to teams.
In the table, some users must have several related teams.
I have created a view of users with this settings:
1 > Add a relationship : The entity reference field of the users (in my team content type)
2 > Add the users fields : Name, firstname, phone....
3 > Add a node title field to display the names of the teams (with the relationship)
But, i get some duplicated users. If a user is associated with several teams, the user has several rows.
I want to have a row by user, with several teams (if necessary) in the teams column. (see image)
I have tested to reduce the duplications the aggregation option without success.
Can you help me to resolve this problem ?
Thanks for your help.
Comments
Comment #1
kumkum29 CreditAttribution: kumkum29 commentedComment #2
kumkum29 CreditAttribution: kumkum29 commentedComment #3
kumkum29 CreditAttribution: kumkum29 commentedHello,
I have resolved my problem with the "Views Distinct" module and using "filter repeats" option on the mail.
But this module is installed only for this problem.
Can i get the same result with a query alter on the view (and groupby on mail) ?
Thanks.
Comment #4
renatogHi @kumkum29, how are you?
I was checking and using Views Distinct for this case is an good solution.
I tested and works good. It can help many people.
Thank you very much.
Comment #5
renatog