Thanks Brian, Paul, and Craig,<br><br>Duhh. Okay, now I see it. I thought I'd have to chose the field and then expected random to be in the drop-down that has ascending/descending.<br><br>But it's not that way, so my eyes missed it.<br>
<br>Thanks much, this is perfect.<br><br>Shai<br><br><div class="gmail_quote">On Tue, Jul 15, 2008 at 6:15 PM, Brian Choc <<a href="mailto:bchoc@t4tcolorado.org">bchoc@t4tcolorado.org</a>> 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 link="blue" vlink="purple" lang="EN-US">
<div>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Add the criteria "Random" (it's listed as a field) … does that
do what you're looking to do?</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);">Brian</span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<p><span style="font-size: 11pt; color: rgb(31, 73, 125);"> </span></p>
<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;">
<a href="mailto:support-bounces@drupal.org" target="_blank">support-bounces@drupal.org</a> [mailto:<a href="mailto:support-bounces@drupal.org" target="_blank">support-bounces@drupal.org</a>] <b>On Behalf Of </b>Shai
Gluskin<br>
<b>Sent:</b> Tuesday, July 15, 2008 4:12 PM<br>
<b>To:</b> <a href="mailto:support@drupal.org" target="_blank">support@drupal.org</a><br>
<b>Subject:</b> [support] Getting A View to "ORDER BY RAND ()"</span></p>
</div><div><div></div><div class="Wj3C7c">
<p> </p>
<p>I have a need for Views to "ORDER BY RAND ()"<br>
<br>
The use-case is that I want to pull in the teaser of a particular content-type
for one node only onto the home page. I want it to randomly select the node it
displays.<br>
<br>
Everything is easy except the random part. The home page is a panel page. I've
built a view, filtered on content-type, set the number of nodes to display at
"1" -- successfully pulled it into the panel.<br>
<br>
I thought the way to do this would be to set a sort criteria. But I see only
"ascending" and "descending" -- I don't see
"random" as a choice.<br>
<br>
Any ideas?<br>
<br>
I'm using Drupal 5.8, Views 1.6 and Panels 2 Beta<br>
<br>
Thanks,<br>
<br>
Shai</p>
</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>