WordPress.org

Ready to get started?Download WordPress

Forums

is there a way to change order in moderation queue? (5 posts)

  1. Run4it
    Member
    Posted 7 years ago #

    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.

  2. whooami
    Member
    Posted 7 years ago #

    what version of wordpress??

  3. whooami
    Member
    Posted 7 years ago #

    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

  4. Run4it
    Member
    Posted 7 years ago #

    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.

  5. whooami
    Member
    Posted 7 years ago #

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

Topic Closed

This topic has been closed to new replies.

About this Topic