Re: ogo task reminder

Hi,

[email protected] wrote: 
> > > FYI, the query I use is:
> > > WHERE "job status" NOT IN  ( '25 done', '30 archived', '02 rejected' ) 
> > > AND is control job IS NULL 
> > > AND start date <  'tomorrow'
> > > AND end date < 'tomorrow'::DATE + INTERVAL '4 days'
> > adding the 02 rejected makes sense to me, but I do not know what the 
> > control job is for?
> 
> Nobody does. :) And they don't seem to occur anymore.  But if you have a
hehe ;)

> system that has been around for awhile (ours has been running since
> 2003?) you are likely to have some floating around in your database.
no, mine are not running since then.

Nevertheless, this reminds me in updating the database query of the logic 
command. 

kind regards
Sebastian

PS: I uploaded a patch for task notifications to be sent out via 
jabber/xmpp, and have it working 95% for appointments too, so expect a patch 
enhancement for skyaptnotify this evening ;)


-- 
OpenGroupware.org Discussion [email protected]
http://mail.opengroupware.org/mailman/listinfo/discuss