[rt-users] HELP..I messed up..and I have 800 pissed off people on my neck.

Per Kristiansen per at gathering.org
Sun Feb 3 15:19:46 EST 2002

On Sun, Feb 03, 2002 at 11:09:19AM -0800, Jim Meyer wrote:
> Particularly (and this is in my Postgres DB, but should work in any SQL
> DB) this query gets me a list of the correspondence since midnight AM
> UTC Jan 13 2002:
> SELECT * FROM attachments WHERE created > '2002-01-31 00:00:00' AND
> content != '';
> I haven't figured out how to relate this to a ticket and queue (and thus
> get the list of who to send it to) and unfortunately I've got to run for
> a while. I'll have a peek at this later today if I can make some time
> and see if I can share anything more.
> Meanwhile, let the 800 people know three things:
> 0) The problem is fixed and all new correspondence will happen as
>    it should (right? =),
> 1) The data is all in there,
> 2) You're working on getting the mail to happen.
> It sounds like a reminder that stress kills might be in order, too.
> Good luck!

When I woke up today it turns out one of the other people working on it
had made a perl program tat fixed it..phu..sometimes I forget how truly
blessed it can be working with people who actually know stuff beyond their
immediate jobs :)

Per Kristiansen
per at gathering.org

More information about the rt-users mailing list