Skip to main content

This site requires you to update your browser. Your browsing experience maybe affected by not having the most up to date version.

Data Model Questions

Getting a set of random data objects


2 Posts   458 Views


23 October 2012 at 12:44pm (Last edited: 23 October 2012 12:55pm), Community Member, 22 Posts

EDIT: Forgot to mention I'm using 2.4.x for this particular project, not SS3.

Hi All,

I'm wondering if somebody could give me some basic guidance with this. It's a fairly simple situation - I have a database with a bunch of product listings. I would like to be able to get a variable number of random products (say, for example, 3) and display them on the homepage of my site. I've managed to get by so far with the existing documentation, can I can't quite get my head around how to achieve this particular task.

Down the track I may want the ability to set specific products to appear on the homepage (I imagine this would just be a simple flag), but right now, I'd just like Sapphire/Silverstripe to grab a bunch at random and stick them up. I imagine this request would be repeated every time the page was refreshed.

Any help - even if it's just pointing me towards the right documentation - would be most appreciated.

I can post more info about my data model (it's reasonably complex with a number of relations) if necessary.

Cheers! Kyle


24 October 2012 at 12:30am Forum Moderator, 1091 Posts

I read a similar post here, that might at least set you on track: