19 Aug 2009 23:00
Getting the Reminder Time
Jon Dodson <jdodson <at> neutralspace.com>
2009-08-19 21:00:33 GMT
2009-08-19 21:00:33 GMT
In the iCalendar format there is a "trigger" value that is a duration for when the reminder is triggered. Cosmo supports this and it seems to be available in the attribute table with the "reminderTime" localname. select * from attribute where localname='reminderTime'; According to the attributetype it says "timestamp" but those numbers are not unix timestamps. Question: What is the intvalue representative of? Is there a better way to get this? I want to basically poll all the events and remind people their events are happening. I want to do this in a mass swath for all users, not for just one. If there is a better way to do this, let me know. The other way I see is to parse out the trigger from the event_stamp table, even though it seems a bit much for getting this value. Thanks! -- -- Jon Dodson Software Engineer neutralSpace, Inc. www.neutralspace.com 2828 SW Corbett Ave, Suite 204(Continue reading)
RSS Feed