diff options
| author | Luke Shumaker <lukeshu@sbcglobal.net> | 2015-04-13 20:25:24 -0400 |
|---|---|---|
| committer | Luke Shumaker <lukeshu@sbcglobal.net> | 2015-04-13 20:25:24 -0400 |
| commit | c266efc7fc73f94995bffcdf8e0ef7a4aeb563c3 (patch) | |
| tree | 2b96d2ff0f7e0a0d164a28b152b51fbb2f87b76f /todolists | |
| parent | ea00a099dffd7157c93af54b5817734348d2bbc6 (diff) | |
| parent | 9589a7eadeb05e82c2d63f6fe128316fdb6dcc8a (diff) | |
Merge tag 'release_2014-10-19' into archweb-generic
Jinja2 switch for some templates, exact matches in package search
Diffstat (limited to 'todolists')
| -rw-r--r-- | todolists/utils.py | 2 |
1 files changed, 1 insertions, 1 deletions
diff --git a/todolists/utils.py b/todolists/utils.py index 7b98c887..e04c2e5e 100644 --- a/todolists/utils.py +++ b/todolists/utils.py @@ -6,7 +6,7 @@ from packages.models import Package def todo_counts(): sql = """ -SELECT todolist_id, count(*), sum(CASE WHEN status = %s THEN 1 ELSE 0 END) +SELECT todolist_id, count(*), SUM(CASE WHEN status = %s THEN 1 ELSE 0 END) FROM todolists_todolistpackage WHERE removed IS NULL GROUP BY todolist_id |