3070 Posts in 869 Topics by 651 members
|Go to End|
11 October 2010 at 11:26pm Last edited: 11 October 2010 11:27pm
I can't get my head round the following ... I hope someone can help
I have an Event DataObject as below and want any events that have taken place not to display when I call the events stored in the database. Ideally, I want to automatically delete the event from the database at the end of the day on which it takes place.
I see the CMS Workflow module has an Expiry method but from what I can gather this only applies to Pages not objects.
class Event extends DataObject
static $db = array (
'EventName' => 'Text',
'Description' => 'Text',
'Date' => 'Date',
'Time' => 'Text',
'Venue' => 'Text',
'ContactNumber' => 'Text'
class EventPage_Controller extends Page_Controller
Many thanks in advance!
12 October 2010 at 7:37am
i guess you can do this by just checking if date has passed in the query which will be generated by silverstripe through the DataObject get method.
return DataObject::get('Event', "Date > NOW()", 'Date DESC');
12 October 2010 at 9:47pm
Thanks bart. It works a treat!
I think I was over-thinking it and expecting it to be more complicated!
|Go to Top|