blob: 0d693a05ce22adea8249c05487607c132a165a4a (
plain) (
blame)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
|
;;; rt-liberation-report.el --- Free from RT
;; Copyright (C) 2015 Yoni Rabkin
;;
;; Authors: Yoni Rabkin <yrk@gnu.org>
;;
;; This program is free software; you can redistribute it and/or
;; modify it under the terms of the GNU General Public License as
;; published by the Free Software Foundation; either version 2 of the
;; License, or (at your option) any later version.
;;
;; This program is distributed in the hope that it will be useful,
;; but WITHOUT ANY WARRANTY; without even the implied warranty of
;; MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
;; GNU General Public License for more details.
;;
;; You should have received a copy of the GNU General Public
;; License along with this program; if not, write to the Free
;; Software Foundation, Inc., 59 Temple Place - Suite 330, Boston,
;; MA 02111-1307, USA.
;;; History:
;;
;; I wrote rt-report.py sometime in 2013 because people asked for some
;; information as to how many tickets were being resolved, and by
;; whom. When in came time up update rt-report.py I came to my senses
;; and decided to re-write it in Emacs Lisp as a part of
;; rt-liberation.
;;; Code:
(require 'rt-liberation-rest)
;; This query works for a single day _BUT_ only if `resolved' is added
;; as a `rt-liber-attrib-p'. The `nil' is the result when there are no
;; tickets to return and the list is what comes back when tickets are
;; found.
;;
;; (rt-liber-rest-run-show-base-query
;; (rt-liber-rest-run-ls-query
;; (rt-liber-compile-query
;; (and (queue "licensing")
;; (resolved "2015-10-09")
;; (status "resolved")))))
;;
;; However, note that the following inequalities work too and would be
;; the right way to do the query:
;;
;; (rt-liber-rest-run-ls-query "Queue = 'licensing' AND Resolved <
;; '2015-10-02' AND Resolved > '2015-09-28' AND Status = 'resolved'")
;;
;; NOTE!!! rt-liberation already supports "temporal" predicates, but I
;; need to add `resolved' ("Resolved") as one of them and check that
;; it works.
;;
;; nil
;;
;; ((("TimeLeft" . "0")
;; ("TimeWorked" . "0")
;; ("TimeEstimated" . "0")
;; ("Told" . "Thu Oct 08 00:53:59 2015")
;; ("Resolved" . "Thu Oct 08 00:53:59 2015")
;; ("Due" . "Not set")
;; ("Started" . "Wed Oct 07 06:52:03 2015")
;; ("Starts" . "Not set")
;; ("Created" . "Wed Oct 07 06:39:22 2015")
;; ("Requestors" . "ian.macintosh@gtxweb.uk")
;; ("FinalPriority" . "0")
;; ("InitialPriority" . "0")
;; ("Priority" . "0")
;; ("Status" . "resolved")
;; ("Subject" . "Badly worded and misleading paragraph")
;; ("Creator" . "ian.macintosh@gtxweb.uk")
;; ("Owner" . "jgay@fsf.org")
;; ("Queue" . "licensing")
;; ("id" . "ticket/1052419"))
;; (("TimeLeft" . "0")
;; ("TimeWorked" . "0")
;; ("TimeEstimated" . "0")
;; ("Told" . "Thu Oct 08 07:54:47 2015")
;; ("Resolved" . "Thu Oct 08 07:54:47 2015")
;; ("Due" . "Not set")
;; ("Started" . "Wed Oct 07 12:03:20 2015")
;; ("Starts" . "Not set")
;; ("Created" . "Mon Sep 21 13:33:24 2015")
;; ("Requestors" . "juan.balderas.0@gmail.com")
;; ("FinalPriority" . "0")
;; ("InitialPriority" . "0")
;; ("Priority" . "0")
;; ("Status" . "resolved")
;; ("Subject" . "Softare donation to FSF")
;; ("Creator" . "juan.balderas.0@gmail.com")
;; ("Owner" . "donald")
;; ("Queue" . "licensing")
;; ("id" . "ticket/1048183")))
(provide 'rt-report)
;;; rt-liberation-report.el ends here.
|
