aboutsummaryrefslogtreecommitdiffstats
path: root/db
diff options
context:
space:
mode:
authormatthew <matthew>2007-05-14 22:12:36 +0000
committermatthew <matthew>2007-05-14 22:12:36 +0000
commitc96e4a09dc233074fc023e49ab2397c5630a131c (patch)
treec6567d8f451bff19215c508b4055e2e05cb2e76b /db
parent8a19fabc7387a9ff2ad8e43e0ce796af69c240a2 (diff)
Deal crappily with alert with a parameter.
Diffstat (limited to 'db')
-rw-r--r--db/alert_types.sql2
1 files changed, 1 insertions, 1 deletions
diff --git a/db/alert_types.sql b/db/alert_types.sql
index 26ef3c265..9b0c99a1b 100644
--- a/db/alert_types.sql
+++ b/db/alert_types.sql
@@ -35,7 +35,7 @@ insert into alert_type
item_title, item_link, item_description, template)
values ('council_problems', '', '',
'New local problems on Neighbourhood Fix-It', '/report', 'The latest local problems reported by users',
- 'problem', 'problem.state in (\'confirmed\', \'fixed\') and council=?', 'created desc',
+ 'problem', 'problem.state in (\'confirmed\', \'fixed\') and council like \'%\'||?||\'%\'', 'created desc',
'{{title}}', '/?id={{id}}', '{{detail}}', 'alert-problem'
);