How do I show only the latest post from each user in a view?

Question

I'm trying to show a list of only the most recently published post by every user (not including the logged in user) in a view. What should my Views filters look like in order to accomplish this? I'm completely stuck!

At the moment, my view shows all posts from all other users. I now need to filter it down once more so that it ONLY shows the most recent post by all of these users.

Reference (issue):

Answer 1

The problem is that you are trying to filter based on two things:

• Show the most recent content by an individual user.
• Show each user.

In Views, you can generally only filter one kind of entity (content OR users) at a time.

However, there is a module that can help, Views Field View. This module lets you embed one view inside another.

So, you can do something like this:

1. Create a view that shows the most recent content for a single user (takes a contextual filter of UID, returns one result, sorted by descending most recent).
2. Create another view that shows all users except the logged in user. Use Views Field View module to embed the first view and show the most recent post by each user.

I haven't done this exact implementation before, but I've used Views Field View for similar things. There is a tutorial here.

If you use this module, do note this warning from the documentation:

Please note that using this module can impact the performance of your site, if the views being rendered are very resource-consuming. It's highly recommended to use this module in conjunction with other modules that provide views caching.

Good candidates to cache your views are the modules Views content cache and Cache Actions.

Answer 2

Latest views Drupal 7 and 8 can do this without needing extra module

Add new view Show: Users

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

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

Sort criteria Add a "Content: 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.