It's in Filters -> Node: Published. On Thu, Jul 30, 2009 at 2:19 PM, Steve Kessler <skessler@denverdataman.com>wrote:

Thank you very much.

There does not appear to be published/unpublished toggle available in views.

Thanks,

Steve

Steve Kessler

*Denver DataMan *

303-587-4428

Sign up for the Denver DataMan Free eNewsletter<http://www.denverdataman.com/content/enewsletter-signup>

*From:* Neil Coghlan [mailto:neil@esl-lounge.com] *Sent:* Thursday, July 30, 2009 11:46 AM *To:* support@drupal.org *Subject:* Re: [support] Comments needing approval block

this is what I have in a block, alongside some other stats:

<b><span style="color:red;"><?php $count_unpub_comm_tot = db_result(db_query("SELECT COUNT(cid) FROM {comments} WHERE `status` = 1")); echo $count_unpub_comm_tot; ?></span></b> <b>Un</b>published Comments

with Views, I imagine it would be even easier, no? Just use unpublished filter. Preferred to roll my own though.

Neil

----- Original Message -----

*From:* Steve Kessler <skessler@denverdataman.com>

*To:* support@drupal.org

*Sent:* Thursday, July 30, 2009 2:28 PM

*Subject:* [support] Comments needing approval block

I am trying to create a block of comments that need approval. I have tried many iterations of ways to do this and I cannot figure it out. I would like to do this with views. If anyone can give me a suggestion I would appreciate it.

Thanks,

Steve

Steve Kessler

*Denver DataMan *

303-587-4428

Sign up for the Denver DataMan Free eNewsletter<http://www.denverdataman.com/content/enewsletter-signup>

------------------------------

-- [ Drupal support list | http://lists.drupal.org/ ]

-- [ Drupal support list | http://lists.drupal.org/ ]

Does not appear to. Steve Kessler Denver DataMan 303-587-4428 Sign <http://www.denverdataman.com/content/enewsletter-signup> up for the Denver DataMan Free eNewsletter From: Brian Choc [mailto:bchoc@t4tcolorado.org] Sent: Friday, July 31, 2009 10:20 PM To: support@drupal.org Subject: Re: [support] Comments needing approval block Sorry, misread that as nodes not comments. Does Filters -> Comment: In moderation do what you want? Brian On Fri, Jul 31, 2009 at 6:37 PM, Brian Choc <bchoc@t4tcolorado.org> wrote: It's in Filters -> Node: Published. On Thu, Jul 30, 2009 at 2:19 PM, Steve Kessler <skessler@denverdataman.com> wrote: Thank you very much. There does not appear to be published/unpublished toggle available in views. Thanks, Steve Steve Kessler Denver DataMan 303-587-4428 Sign <http://www.denverdataman.com/content/enewsletter-signup> up for the Denver DataMan Free eNewsletter From: Neil Coghlan [mailto:neil@esl-lounge.com] Sent: Thursday, July 30, 2009 11:46 AM To: support@drupal.org Subject: Re: [support] Comments needing approval block this is what I have in a block, alongside some other stats: <b><span style="color:red;"><?php $count_unpub_comm_tot = db_result(db_query("SELECT COUNT(cid) FROM {comments} WHERE `status` = 1")); echo $count_unpub_comm_tot; ?></span></b> <b>Un</b>published Comments with Views, I imagine it would be even easier, no? Just use unpublished filter. Preferred to roll my own though. Neil ----- Original Message ----- From: Steve Kessler <mailto:skessler@denverdataman.com> To: support@drupal.org Sent: Thursday, July 30, 2009 2:28 PM Subject: [support] Comments needing approval block I am trying to create a block of comments that need approval. I have tried many iterations of ways to do this and I cannot figure it out. I would like to do this with views. If anyone can give me a suggestion I would appreciate it. Thanks, Steve Steve Kessler Denver DataMan 303-587-4428 Sign <http://www.denverdataman.com/content/enewsletter-signup> up for the Denver DataMan Free eNewsletter _____ -- [ Drupal support list | http://lists.drupal.org/ ] -- [ Drupal support list | http://lists.drupal.org/ ]