views=filter the Node:New Comments = where is it ?

By vertazzar on 8 May 2009 at 14:06 UTC

Why the views doesn't have the ability to filter the nodes only who have new comments -_-

there's only for Node:Has a new content

....

Is there a way to make views filter only nodes with new comments?

Comments

bump

vertazzar commented 9 May 2009 at 07:27

bump

BUMP - Desperately need this

DarkLight commented 6 June 2010 at 20:56

BUMP - Desperately need this filter, guys! :/ Any news?

Try this

Leksat commented 20 March 2011 at 11:09

You can use filter "Has new content" with a little modification.

/**
 * Implementation of hook_views_query_alter().
 */
function MODULENAME_views_query_alter(&$view, &$query) {
  
  // Modify filter "Has new content" to "Has new comments".
  if ($view->name == 'VIEWNAME') {
    foreach ($query->where[0]['clauses'] as &$clause) {
      if (strstr($clause, 'last_comment_timestamp')) {
        $clause = 'history_user.timestamp < node_comment_statistics.last_comment_timestamp';
      }
    }
  }
}

Thank you thank you thank

mr.j commented 1 April 2011 at 06:17

Thank you thank you thank you.

BTW for D7 you should switch

Georgii commented 29 September 2011 at 20:50

BTW for D7 you should switch to

/**
* Implementation of hook_views_query_alter().
*/
function MODULENAME_views_query_alter(&$view, &$query) {
 
  // Modify filter "Has new content" to "Has new comments".
  if ($view->name == 'VIEWNAME') {
    foreach ($query->where[0]['conditions'] as &$clause) {
      if (strstr($clause['field'], 'last_comment_timestamp')) {
        $clause['field'] = 'history.timestamp < node_comment_statistics.last_comment_timestamp';
      }
    }
  }
}

D7 code is not working for me...

JLeMosy commented 20 June 2012 at 21:23

I've created a module called "utm_mods" that includes only the following PHP code, and I'm still unable to get Views 3 to include comments in the "Has new content" filter. Not sure what I'm missing here, or even if I'm doing this quite right...

/**
 * Implementation of hook_views_api().
 */
function utm_mods_views_api() { // your module name into hook_views_api
  return array(
    'api' => 3,
    // might not need the line below, but in any case, the last arg is the name of your module
    'path' => drupal_get_path('module', 'utm_mods'),
  );
}

/**
* Implementation of hook_views_query_alter().
*/
function utm_mods_views_query_alter(&$view, &$query) {
  // Modify filter "Has new content" to "Has new comments".
  if ($view->name == 'whats_new') {
    foreach ($query->where[0]['conditions'] as &$clause) {
      if (strstr($clause['field'], 'last_comment_timestamp')) {
        $clause['field'] = 'history.timestamp < node_comment_statistics.last_comment_timestamp';
      }
    }
  }
}

Any help wold be great...Thanks!

did you make any progress?

antoinetooley commented 4 September 2013 at 17:30

Hey JLeMosy,
did you manage toget this working in the end? I am after this functionality but I can't seem to get any response from my view. Would really apprecaite any help if you did suceed in the end or if anyone else knows what is wrong here?

One thing though is I don't want to replace new content filter I just want to add a new filter whih searched for nodes with new comments so I can use both simultaneously. Does anyone know if this still possible with this custom module approach?

Thanks

Antoine