CB 2.0.3: List sorting randomly
nant
9 years 5 months ago #253949
by nant
The internet is full of such examples
Here is one I found:
stackoverflow.com/questions/1117761/sql-query-to-return-rows-in-random-order
Based on this, your CB 2.0 userlist Sort tab Advanced setting should simply be:
RAND()
and you should get random listings.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Replied by nant on topic CB 2.0.3: List sorting randomly
giecie wrote: CB 2.0.3
J3.3.6
How can I sort a CB list randomly on the field 'name'.
In CB1.9.1 I was able to select sort by: Sort Randomly [ASC].
How can I do this selection in CB2.0.3?
I think via ADVANCED and an SQL statement?
Can you give me an SQL examle?
Br.
The internet is full of such examples
Here is one I found:
stackoverflow.com/questions/1117761/sql-query-to-return-rows-in-random-order
Based on this, your CB 2.0 userlist Sort tab Advanced setting should simply be:
RAND()
and you should get random listings.
--
Nick (nant)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Tutorials + Search the forums
For more add-ons and support: Upgrade your membership
Links: Community Builder - Languages - Adv/Pro/Dev membership - CBSubs Paid Subscriptions - GPL Templates - Hosting
Visit my CB Profile - Send me a Private Message (PM)
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.300 seconds
