[rt-devel] Due Dates

[Brandon S. Allbery KF8NH]

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.
+--->8

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.

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


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

_______________________________________________
rt-users mailing list
rt-users at lists.fsck.com
http://lists.fsck.com/mailman/listinfo/rt-users

-- 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]