WordPress.org

Support

Support » How-To and Troubleshooting » is there a way to change order in moderation queue?

is there a way to change order in moderation queue?

  • I realize this sounds counter-intuitive, but is there a way to change the order of the comments in the moderation queue so that newsest ones are first? Here’s why I want to do that.

    The blog I hope to build will be for a state government agency. We have to moderate every comment but we have been advised that we HAVE TO KEEP every comment that we elect not to publish. This doesn’t extend to spam. The only way I can think to keep it is to leave it in the queue because it appears that there is not a “Do Not Publish” option, only a delete option. This means it will stay in the queue and become a nuisance by virtue of always appearing at the top.

    If anyone has another alternative, I’d love to hear it.

    Thanks.

Viewing 4 replies - 1 through 4 (of 4 total)
  • whooami

    @whooami

    Member

    what version of wordpress??

    whooami

    @whooami

    Member

    in 2.2 just open wp-admin/moderation.php and edit the query,

    $comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_approved = '0'");

    $comments = $wpdb->get_results("SELECT * FROM $wpdb->comments WHERE comment_approved = '0' ORDER BY comment_date DESC ");

    worked for me

    I’m assuming there is not way for me to do this at wordpress.com? I am “playing” around with WordPress over there in order to evaluate it, but will probably go with a paid host when I get ready to launch.

    whooami

    @whooami

    Member

    No, of course you cannot do this at wordpress.com

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘is there a way to change order in moderation queue?’ is closed to new replies.
Skip to toolbar