By hubertusanton on

Hi,

I created a view in the views module which displays the blogs posted by all the users on my site.

Is it posible to do a 'distinct' argument to only display every user in this list once?

⋅ Categories: Drupal 5.x

Comments

marcvangend’s picture

marcvangend
he/him
Primary language Dutch
Location Amsterdam
commented

interesting question, I don't have an answer straight away. I just want to make sure I understand your question correctly: Are you trying to create a list of each user's latest post?

ff1’s picture

ff1 commented

In the 'fields' section of the view edit page, select 'Group multiple values' for the 'Handler' of the user field.

hubertusanton’s picture

hubertusanton commented

Hmmm

There is no select option for Handler in Node: Author Name row.

maco’s picture

maco commented

On Views edit page go to Filters and Add Filter of type "Node: Distinct", save twice

ablankenstein’s picture

ablankenstein commented

this won't work either. He wants a distinct user filter. Not on a node. Another blogpost of the same user will still be displayed.
Anyone else? I need this too..

Anonymous’s picture

Anonymous (not verified) commented

i realise this is old, but i found it when looking to solve a similar problem, so thought i'd post my solution: you can alter the SQL statement before it gets executed: http://echodittolabs.org/blog/2010/06/group-views

marcvangend’s picture

marcvangend
he/him
Primary language Dutch
Location Amsterdam
commented

Thanks. In fact, this topic is so old that it dates from the Views 1 period. If I'm not mistaken, this wasn't possible back then. I hope that your link will help anyone stumbling upon this issue.

sandip27’s picture

sandip27 commented

Actually, solution at http://echodittolabs.org/blog/2010/06/group-views is pretty good, however, if you dont want to do it through code and still want to achieve it.. then, May be enabling "Aggregation" to the view and then Apply Count() to one of user related field will help... I tried it and solved my issue, could help you in your problem...