[tryton-commits] changeset in bugs.tryton.org:default Use proper status IDs for r...

[Cédric Krier]

changeset 5a147575da4d in bugs.tryton.org:default
details: https://hg.tryton.org/bugs.tryton.org?cmd=changeset&node=5a147575da4d
description:
        Use proper status IDs for resolved statistic
diffstat:

 issue-stats.sql |  2 +-
 1 files changed, 1 insertions(+), 1 deletions(-)

diffs (10 lines):

diff -r a9e69037875a -r 5a147575da4d issue-stats.sql
--- a/issue-stats.sql   Sun Sep 05 01:01:19 2021 +0200
+++ b/issue-stats.sql   Sun Sep 05 01:59:11 2021 +0200
@@ -1,5 +1,5 @@
 SELECT CAST(date AS DATE), SUM(new) AS new, SUM(resolved) AS resolve FROM (
-    SELECT DATE_TRUNC('month', _activity) AS date, 0 as new, 1 AS resolved 
FROM _issue WHERE _status <= 7
+    SELECT DATE_TRUNC('month', _activity) AS date, 0 as new, 1 AS resolved 
FROM _issue WHERE _status IN (7, 8, 9, 10)
     UNION ALL
     SELECT DATE_TRUNC('month', _creation) AS date, 1 as new, 0 as resolved 
FROM _issue) AS report
 GROUP BY date ORDER BY date DESC;