diff options
-rw-r--r-- | db/alert_types.sql | 2 |
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' ); |