It&#39;s in Filters -&gt; Node: Published.<br><br><div class="gmail_quote">On Thu, Jul 30, 2009 at 2:19 PM, Steve Kessler <span dir="ltr">&lt;<a href="mailto:skessler@denverdataman.com">skessler@denverdataman.com</a>&gt;</span> wrote:<br>
<blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">









<div bgcolor="white" link="blue" vlink="purple" lang="EN-US">

<div>

<p><span style="color: rgb(31, 73, 125);">Thank you very much. </span></p>

<p><span style="color: rgb(31, 73, 125);"> </span></p>

<p><span style="color: rgb(31, 73, 125);">There does not appear to be
published/unpublished toggle available in views. </span></p><div class="im">

<p><span style="color: rgb(31, 73, 125);"> </span></p>

<p><span style="color: rgb(31, 73, 125);">Thanks,</span></p>

<p><span style="color: rgb(31, 73, 125);">Steve</span></p>

<p><span style="color: rgb(31, 73, 125);"> </span></p>

<div>

<p><span style="color: rgb(31, 73, 125);">Steve
Kessler </span></p>

<p><b><span style="color: rgb(72, 110, 149);">Denver DataMan </span></b></p>

<p><span style="color: rgb(31, 73, 125);">303-587-4428
</span></p>

<p><span style="color: rgb(31, 73, 125);"><a href="http://www.denverdataman.com/content/enewsletter-signup" target="_blank">Sign up for the
Denver DataMan Free eNewsletter</a></span><span style="color: rgb(31, 73, 125);"></span></p>

</div>

<p><span style="color: rgb(31, 73, 125);"> </span></p>

</div><div>

<div style="border-style: solid none none; border-color: rgb(181, 196, 223) -moz-use-text-color -moz-use-text-color; border-width: 1pt medium medium; padding: 3pt 0in 0in;">

<p><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> Neil Coghlan
[mailto:<a href="mailto:neil@esl-lounge.com" target="_blank">neil@esl-lounge.com</a>] <br>
<b>Sent:</b> Thursday, July 30, 2009 11:46 AM<br>
<b>To:</b> <a href="mailto:support@drupal.org" target="_blank">support@drupal.org</a><br>
<b>Subject:</b> Re: [support] Comments needing approval block</span></p>

</div>

</div><div><div></div><div class="h5">

<p> </p>

<div>

<p><span style="font-size: 10pt;">this
is what I have in a block, alongside some other stats:</span><span style="font-size: 12pt; font-family: &quot;Times New Roman&quot;,&quot;serif&quot;;"></span></p>

</div>

<div>

<p><span style="font-size: 12pt; font-family: &quot;Times New Roman&quot;,&quot;serif&quot;;"> </span></p>

</div>

<div>

<p><span style="font-size: 10pt;">&lt;b&gt;&lt;span
style=&quot;color:red;&quot;&gt;&lt;?php<br>
$count_unpub_comm_tot = db_result(db_query(&quot;SELECT COUNT(cid) FROM
{comments} WHERE `status` = 1&quot;));<br>
echo $count_unpub_comm_tot;<br>
?&gt;&lt;/span&gt;&lt;/b&gt; &lt;b&gt;Un&lt;/b&gt;published Comments</span><span style="font-size: 12pt; font-family: &quot;Times New Roman&quot;,&quot;serif&quot;;"></span></p>

</div>

<div>

<p><span style="font-size: 12pt; font-family: &quot;Times New Roman&quot;,&quot;serif&quot;;"> </span></p>

</div>

<div>

<p><span style="font-size: 10pt;">with
Views, I imagine it would be even easier, no? Just use unpublished filter.
Preferred to roll my own though.</span><span style="font-size: 12pt; font-family: &quot;Times New Roman&quot;,&quot;serif&quot;;"></span></p>

</div>

<div>

<p><span style="font-size: 12pt; font-family: &quot;Times New Roman&quot;,&quot;serif&quot;;"> </span></p>

</div>

<div>

<p><span style="font-size: 10pt;">Neil</span><span style="font-size: 12pt; font-family: &quot;Times New Roman&quot;,&quot;serif&quot;;"></span></p>

</div>

<blockquote style="border-style: none none none solid; border-color: -moz-use-text-color -moz-use-text-color -moz-use-text-color black; border-width: medium medium medium 1.5pt; margin: 5pt 0in 5pt 3.75pt; padding: 0in 0in 0in 4pt;">


<div>

<p><span style="font-size: 10pt;">-----
Original Message ----- </span></p>

</div>

<div>

<p style="background: rgb(228, 228, 228) none repeat scroll 0% 0%; -moz-background-clip: -moz-initial; -moz-background-origin: -moz-initial; -moz-background-inline-policy: -moz-initial;"><b><span style="font-size: 10pt;">From:</span></b><span style="font-size: 10pt;"> <a href="mailto:skessler@denverdataman.com" title="skessler@denverdataman.com" target="_blank">Steve Kessler</a> </span></p>


</div>

<div>

<p><b><span style="font-size: 10pt;">To:</span></b><span style="font-size: 10pt;"> <a href="mailto:support@drupal.org" title="support@drupal.org" target="_blank">support@drupal.org</a>
</span></p>

</div>

<div>

<p><b><span style="font-size: 10pt;">Sent:</span></b><span style="font-size: 10pt;"> Thursday, July 30,
2009 2:28 PM</span></p>

</div>

<div>

<p><b><span style="font-size: 10pt;">Subject:</span></b><span style="font-size: 10pt;"> [support] Comments
needing approval block</span></p>

</div>

<div>

<p><span style="font-size: 12pt; font-family: &quot;Times New Roman&quot;,&quot;serif&quot;;"> </span></p>

</div>

<p>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.</p>

<p> </p>

<p>Thanks,</p>

<p>Steve</p>

<p> </p>

<p><span style="color: rgb(31, 73, 125);">Steve
Kessler </span></p>

<p><b><span style="color: rgb(72, 110, 149);">Denver DataMan </span></b></p>

<p><span style="color: rgb(31, 73, 125);">303-587-4428
</span></p>

<p><span style="color: rgb(31, 73, 125);"><a href="http://www.denverdataman.com/content/enewsletter-signup" target="_blank">Sign up for the
Denver DataMan Free eNewsletter</a></span></p>

<p> </p>

<div style="text-align: center;" align="center"><span style="font-size: 12pt; font-family: &quot;Times New Roman&quot;,&quot;serif&quot;;">

<hr align="center" size="2" width="100%">

</span></div>

<p><span style="font-size: 12pt; font-family: &quot;Times New Roman&quot;,&quot;serif&quot;;">--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]</span></p>

</blockquote>

</div></div></div>

</div>


<br>--<br>
[ Drupal support list | <a href="http://lists.drupal.org/" target="_blank">http://lists.drupal.org/</a> ]<br></blockquote></div><br><br>