Jon Dodson | 19 Aug 2009 23:00
Favicon

Getting the Reminder Time

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)


Gmane