How to orderby comment date

  • Pete

    (@perthmetro)


    10 years ago

    How would I edit this to order the posts by the latest comment, or order by comment date.

    function order_home_asc($query) {
  if ($query->is_home() && $query->is_main_query()) {
    $query->set('orderby', 'modified');
'orderby' => 'comment_count', 'order'=>'DESC'
	$query->set('order', 'DESC');
	$query->set('post_status', 'future,publish');
  }
}
add_action('pre_get_posts', 'order_home_asc');

    Thanks,Pete

Viewing 1 replies (of 1 total)
  • Moderator bcworkz

    (@bcworkz)

    10 years ago

    You can’t do this through the query passed in ‘pre_get_posts’. You are limited by the options listed in https://codex.ww.wp.xz.cn/Class_Reference/WP_Query#Order_.26_Orderby_Parameters

    It can probably be done with a custom SQL query, but such a query is beyond by ability because we’d need a sub-query to first identify the latest comment for each post before ordering the posts.

    It’s possible to sort the posts with PHP just before the main loop by running another loop that finds the latest comment date for each post and adds the comment’s timestamp to the associated array element. The post results array can then be sorted on that value before entering the main loop.

Viewing 1 replies (of 1 total)

The topic ‘How to orderby comment date’ is closed to new replies.