[rt-devel] Due Dates

Brandon S. Allbery KF8NH allbery at ece.cmu.edu
Tue Jan 16 10:14:31 EST 2001

On Tuesday, January 16, 2001 09:34:12 -0500, Jesse <jesse at fsck.com> wrote:
| That's actually a different issue.  The priority escalation stuff was
| for functionality that was never implemented.  I seem to recall that
| someone posted a shell script that could be run from cron to fix this,
| but I don't know where it got to.  If somoene can point me at the message
| in the archives or bounce me another copy, I'll drop it in /contrib.

Message-ID: <39FCECD5.8000101 at seindal.dk>
Date: Mon, 30 Oct 2000 04:36:53 +0100
From: =?ISO-8859-1?Q?Ren=E9?= Seindal <rene at seindal.dk>
Organization: Seindal Consult
To: Request Tracker Users <rt-users at lists.fsck.com>
Subject: [rt-users] Adjusting priorities

Dear RT-users,

This little script will adjust the priority of all open and non overdue tickets towards the final priority. The change is linear so each tickets priority moves from the initial priority towards the final priority at a constant speed. A tickets priority will only be changed upwards, so a ticket that has had its priority raised won't have it lowered automatically. The opposite is not true, so a ticket that has been given a lower priority will have it raised again.

This script will have no effect on tickets that are not open or stalled, tickets without a due date, and tickets where the final priority is equal to the initial priority.

mysql rt <<EOF
update each_req set priority=greatest(priority,
*(unix_timestamp()-date_created) +initial_priority))
where date_due > unix_timestamp()
and status in ('open','stalled');

-- René Seindal (rene at seindal.dk)              http://www.seindal.dk/rene/

rt-users mailing list
rt-users at lists.fsck.com

-- brandon s. allbery     [os/2][linux][solaris][japh]   allbery at kf8nh.apk.net
system administrator        [WAY too many hats]         allbery at ece.cmu.edu
electrical and computer engineering                                   KF8NH
carnegie mellon university     ["better check the oblivious first" -ke6sls]

More information about the Rt-devel mailing list