[rt-users] implementing an almost realtime status box

[Ruslan U. Zakirov]

Kaj J.Niemi wrote:
> Hi,
> 
> 
> I've been asked to check out how hard it would be to implement functionality
> to RT 3.2 (3.2.2 now) giving managers a quick overview on what's happening
> to tickets. Ideally this should just be another box below Quick ticket
> creation on RT's home page. It could look like this:
> 
> # Wed Oct 06 00:16:54 2004 (#25000) user - Status changed from new to resolved
> # Mon Sep 20 11:26:40 2004 (#22222) user - Queue changed from q1 to q2
> # Sun Sep 19 01:41:13 2004 (#12345) user - Priority changed from 0 to 70
> # Sun Sep 19 00:16:47 2004 (#12345) user - Status changed from new to open
> 
> Having looked through the schema and Display.html it seems like I should
> get a list of the 10 most recently updated tickets using Tickets.LastUpdated,
> sort the results descending. Then, for each and every ticket returned, I
> should get the list of transactions and in descending order using
> Transactions.Created take N (thinking 1-3) print them out to something that
> resembles the example above.
I think you should start not from Tickets, but from Transactions and 
order them by Created time and id. From each transaction you can get its 
ticket.


> 
> Has anyone implemented anything like this before? Would this be useful for
> anyone else? I guess I should somehow attempt to translate the above to
> existing function calls in the RT api, any pointers?
Look on history page and investigate how RT get short description for 
transactions.


> 
> Thanks. :)
> 
> 
> 
> // kaj
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Be sure to check out the RT wiki at http://wiki.bestpractical.com