Hi,
Okay, all right, [*took a deep breath*]
I hope i can explain this correctly cause it is a little complex and my english is poor.

I want to list each user with their only latest updated node title in a block in front page. So for example if the User 3 has posted or updated 2 post within last hour, only the one which is newer is displayed not both of them.

-= Recently Update their page =-
User 8 | Hey
User 3 | Oh no
User 6 | yes

Or Let's put it this way, how to create a view where all users are sorted by the date they have updated a node belonging to them.

If this is the sorted table:

#1 | User 8 | Node Title | Updated Date 7/19/2012 13:14
#2 | User 3 | Node Title | Updated Date 6/19/2012 20:08
#3 | User 6 | Node Title | Updated Date 6/19/2012 19:08
.
.
#x | User x (Last One) | Node Title | Updated Date 1/2/2012 00:00

Is this possible with the latest version of drupal and views?
Thank you for your time.

Comments

damiankloip’s picture

damiankloip commented
Status: Active » Fixed

You should be able to do this by creating a relationship to the node author. You will then have access to their name etc...

sa3er’s picture

sa3er commented
Status: Fixed » Active

Thanks for your attention.

But sorry dude, it seems you did not understand what I really meant.
I've already added Node:Author relationship, right, but the problem is it shows all of nodes updated belonging to each user, not just the latest one. It does not list only one node per author

I want a list of all users which is sorted by the date they have updated a node belonging to them. Not all nodes just the most recent one!

#1 | User 8 | Node Title | Updated Date 7/19/2012 13:14
#2 | User 3 | Node Title | Updated Date 6/19/2012 20:08
#3 | User 6 | Node Title | Updated Date 6/19/2012 19:08

Is this possible with the current day technology?
Any help is greatly appreciated.

sa3er’s picture

sa3er commented
Status: Active » Fixed

figured it out, couldn't really believe there's something Views 3 can't do.
I'll put instruction here for people who might come later with the same issue.

+ Add new view
Show: Users

Relationships
+ Add a relationshop "User: Representative node"
Change "Representative sort criteria" to "Node: Updated date"

FIELDS
+ Add a "Node:Title" field and make sure the Relationship is set to "Representative node"

Sort criteria
+ Add a "Node: Updated date" to Sort criteria section and again make sure the Relationship is set to "Representative node" and also the "Sort descending" radio box is checked.

Congratulations, you've just done it! ;)

Status: Fixed » Closed (fixed)

Automatically closed -- issue fixed for 2 weeks with no activity.

kaypro4’s picture

kaypro4 commented
Issue summary: View changes

This worked great for me, however, don't forget to flush the cache or the "Representative sort order" does not apply.

https://www.drupal.org/node/1788798

Working great after that!