Hi,
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.
mysite/code/Event.php
class Event extends DataObject
{
static $db = array (
'EventName' => 'Text',
'Description' => 'Text',
'Date' => 'Date',
'Time' => 'Text',
'Venue' => 'Text',
'ContactNumber' => 'Text'
);
...
...
mysite/code/EventPage.php
class EventPage_Controller extends Page_Controller
{
function Event()
{
return DataObject::get(
'Event',
null,
'Date ASC',
null
);
}
Many thanks in advance!