I have a need for Views to "ORDER BY RAND ()"
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.
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.
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.
Any ideas?
I'm using Drupal 5.8, Views 1.6 and Panels 2 Beta
Thanks,
Shai
There IS a sort criteria called "Random" in the drop-down list. You're probably not looking closely enough.
Shai Gluskin wrote:
I have a need for Views to "ORDER BY RAND ()"
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.
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.
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.
Any ideas?
I'm using Drupal 5.8, Views 1.6 and Panels 2 Beta
Thanks,
Shai
Add the criteria "Random" (it's listed as a field) . does that do what you're looking to do?
Brian
From: support-bounces@drupal.org [mailto:support-bounces@drupal.org] On Behalf Of Shai Gluskin Sent: Tuesday, July 15, 2008 4:12 PM To: support@drupal.org Subject: [support] Getting A View to "ORDER BY RAND ()"
I have a need for Views to "ORDER BY RAND ()"
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.
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.
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.
Any ideas?
I'm using Drupal 5.8, Views 1.6 and Panels 2 Beta
Thanks,
Shai
Thanks Brian, Paul, and Craig,
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.
But it's not that way, so my eyes missed it.
Thanks much, this is perfect.
Shai
On Tue, Jul 15, 2008 at 6:15 PM, Brian Choc bchoc@t4tcolorado.org wrote:
Add the criteria "Random" (it's listed as a field) … does that do what you're looking to do?
Brian
*From:* support-bounces@drupal.org [mailto:support-bounces@drupal.org] *On Behalf Of *Shai Gluskin *Sent:* Tuesday, July 15, 2008 4:12 PM *To:* support@drupal.org *Subject:* [support] Getting A View to "ORDER BY RAND ()"
I have a need for Views to "ORDER BY RAND ()"
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.
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.
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.
Any ideas?
I'm using Drupal 5.8, Views 1.6 and Panels 2 Beta
Thanks,
Shai
-- [ Drupal support list | http://lists.drupal.org/ ]
Under Sort Criteria, select Random as the field.
Craig
On Tue, Jul 15, 2008 at 4:12 PM, Shai Gluskin shai@content2zero.com wrote:
I have a need for Views to "ORDER BY RAND ()"
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.
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.
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.
Any ideas?
I'm using Drupal 5.8, Views 1.6 and Panels 2 Beta
Thanks,
Shai
-- [ Drupal support list | http://lists.drupal.org/ ]
-
Brian Choc -
Craig Jackson -
Paul Kim -
Shai Gluskin