X-Git-Url: http://git.onelab.eu/?a=blobdiff_plain;f=rt.py;fp=rt.py;h=4a9c3fd9c5f837dd7118c5abbac01b50d5da8acb;hb=d0652340b89d51c6115edb13d5c7c72b34dea66f;hp=4a951b98c65a970252e1a077654a3cd73262ecf0;hpb=9a5afb968bf6ee5c9b03470c957b98906d3b78a9;p=monitor.git

diff --git a/rt.py b/rt.py
index 4a951b9..4a9c3fd 100644
--- a/rt.py
+++ b/rt.py
@@ -142,7 +142,7 @@ def rt_tickets():
 #WHERE Tk.Queue != 10 AND Tk.id > 10000 AND 
 #Tr.id=At.TransactionID AND ( Tk.Status = 'open' OR
 #Tk.Status = 'new') """
-	sqlall = """SELECT distinct Tk.id, Tk.Status, Tk.Subject, At.Content, Us.EmailAddress, Tk.LastUpdated FROM Tickets AS Tk, Attachments AS At, Users as Us JOIN Transactions AS Tr ON Tk.id=Tr.ObjectId WHERE (Tk.Queue=3 OR Tk.Queue=22) AND Tk.id > 10000 AND Tr.id=At.TransactionID AND ( Tk.Status = 'open' OR Tk.Status = 'new') AND Us.id=Tk.LastUpdatedBy """
+	sqlall = """SELECT distinct Tk.id, Tk.Status, Tk.Subject, At.Content, Us.EmailAddress, Tk.LastUpdated, Q.Name, Tk.Owner FROM Tickets AS Tk, Attachments AS At, Queues as Q, Users as Us JOIN Transactions AS Tr ON Tk.id=Tr.ObjectId WHERE (Tk.Queue=3 OR Tk.Queue=22) AND Tk.id > 10000 AND Tr.id=At.TransactionID AND ( Tk.Status = 'open' OR Tk.Status = 'new') AND Us.id=Tk.LastUpdatedBy AND Q.id=Tk.Queue """
 
 
 	raw = fetch_from_db(db, sql)
@@ -163,6 +163,8 @@ def rt_tickets():
 				"content":str(x[3]),
 				"email":str(x[4]),
 				"lastupdated":str(x[5]),
+				"queue":str(x[6]),
+				"owner":str(x[7]),
 				},
 				raw)