ExpressionEngine CMS
Open, Free, Amazing

Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

how to get list of "closed" comments?

July 17, 2008 6:24pm

Subscribe [3]
  • #1 / Jul 17, 2008 6:24pm

    usclib

    6 posts

    I’m trying to create an rss feed for all comments with status “Closed” in a weblog, meaning comments that have not yet been moderated (not for closed weblog entries). I’d like to use the feed as an alternate notification system instead of email. The comment entry tag apparently does not have a parameter for status; is there another easy way to get this list or will it have to be a custom query?

  • #2 / Jul 17, 2008 6:32pm

    Ingmar

    29245 posts

    I’d say a query:

    SELECT * FROM `exp_comments` WHERE status <> "o"

    Moving to Howto.

  • #3 / Aug 28, 2008 1:40pm

    paulp

    38 posts

    this is related to a problem i’m experiencing.  the comment entry tag is displaying all recent comments on my homepage, even if the comment is in an entry which has since closed.  is there a way to add a parameter that displays comments from only open entries?

.(JavaScript must be enabled to view this email address)

ExpressionEngine News!

#eecms, #events, #releases