[support] Comments needing approval block

[Brian Choc]

It's in Filters -> Node: Published.

On Thu, Jul 30, 2009 at 2:19 PM, Steve Kessler
<skessler at 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 at esl-lounge.com]
> *Sent:* Thursday, July 30, 2009 11:46 AM
> *To:* support at 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 at denverdataman.com>
>
> *To:* support at 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/ ]
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.drupal.org/pipermail/support/attachments/20090731/08c89e1b/attachment-0001.htm>