diff options
| author | Luke Shumaker <lukeshu@sbcglobal.net> | 2015-04-13 21:00:49 -0400 |
|---|---|---|
| committer | Luke Shumaker <lukeshu@sbcglobal.net> | 2015-04-13 21:00:49 -0400 |
| commit | 7aab774ad05b81eb204774bf17cc613401310f7b (patch) | |
| tree | 812929abb2ae6fae90e6a56d4237738d7ca62a8f /todolists | |
| parent | 355087ebe2e3fbd5f860e4655888a89d9df52e34 (diff) | |
| parent | c266efc7fc73f94995bffcdf8e0ef7a4aeb563c3 (diff) | |
Merge tag 'release_2014-10-19' into archweb-generic
Jinja2 switch for some templates, exact matches in package search
# Conflicts:
# templates/packages/search.html
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 |