Automatically move events to Past Events
4 posts by 2 authors in: Forums > CMS Builder
Last Post: May 19, 2010 (RSS)
By zip222 - May 19, 2010
I have an events section that has a list of Upcoming Events and a list of Past Events. I was wondering if there is a way to automatically move events to Past Events once the event date has passed.
Could the "removeDate" field work for this?
Could the "removeDate" field work for this?
Re: [zip222] Automatically move events to Past Events
By Jason - May 19, 2010
Hi,
Yes, this should work. After the "removeDate" has been passed, the even will no long display on upcoming events. You could have a past events page, however, that could specifically search for events past their removeDate.
Great idea!
Yes, this should work. After the "removeDate" has been passed, the even will no long display on upcoming events. You could have a past events page, however, that could specifically search for events past their removeDate.
Great idea!
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Re: [Jason] Automatically move events to Past Events
By zip222 - May 19, 2010
what would I need to include in the list viewer code for the past event page?
Re: [zip222] Automatically move events to Past Events
By Jason - May 19, 2010
Hi,
In your list viewer, you would need to use this to get your records:
You'll need to change names to match what you have in your database.
The 'where' field will return all records that have a removeDate that was before the current day.
It is very important to also have the line:
'ignoreRemoveDate'=>true,
otherwise it will return no records.
Hope this helps.
In your list viewer, you would need to use this to get your records:
list($pastRecords,$pastMetaData)=getRecords(array(
'tableName' => 'events',
'where' => 'removeDate < NOW()',
'ignoreRemoveDate'=>true,
));
You'll need to change names to match what you have in your database.
The 'where' field will return all records that have a removeDate that was before the current day.
It is very important to also have the line:
'ignoreRemoveDate'=>true,
otherwise it will return no records.
Hope this helps.
---------------------------------------------------
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/
Jason Sauchuk - Project Manager
interactivetools.com
Hire me! Save time by getting our experts to help with your project.
http://www.interactivetools.com/consulting/