Sorry for the dumb question, but I've been trying to do this for ages...

How do you create a view that lists all posts that have been updated (not new posts, only updated posts - I dont want to use comment activity timestamp which lists new posts, updated posts and comments on posts).

Another way to put it is, in the node table I only want to see records where 'created' date is not equal to 'changed' date (when created=changed it means its a new post).

Thanks for any help as this has been driving me crazy.

Comments

dawehner’s picture

dawehner
Primary language German
commented

This is currently not possible without custom coding.

In general you could either use some dirty hook_views_query_alter or write a real views integration and provide a filter which does what you want.

Therefore it's really really really helpful to read the api section of views help.
Views can't do this out of the box at the moment.

kars-t’s picture

kars-t commented
Status: Active » Fixed

Hi

I am closing this issue to clean up the issue queue. Feel free to reopen the issue if there is new information and the problem still resides. If not please make sure you close your issues that you don't need any more.

Maybe you can get support from the local user group. Please take a look at this list at groups.drupal.org.

Status: Fixed » Closed (fixed)

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

fourmi4x’s picture

fourmi4x commented

Hi, I need precisely that, here is a code for a custom module (in a custommodule.views.inc file) to alter the view query and show only revisions, not node creations:

function custommodule_views_query_alter(&$view, &$query) {
	if ($view->name=='moderation_revisions_byothers') { // targeting a specific view
	    $query->where[0]['clauses'][] = "node_revisions.vid <> node.vid"; // only show revisions
	    $query->where[0]['clauses'][] = "users_node_revisions.uid <> node.uid"; // bonus : only show revisions that were made by someone else than the author of the node
	}
}