Re: ogo task reminder

> > 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
system that has been around for awhile (ours has been running since
2003?) you are likely to have some floating around in your database.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQBF/o+BLRePpNle04MRAuNCAJ9Gq5Gx1p4MOgTqBGETsfyvpMhnfQCdE16g
hV/zSo5ekb4rtM+UXEMKk3k=
=lA8Q
-----END PGP SIGNATURE-----