diff options
| author | Matthew Somerville <matthew@mysociety.org> | 2010-12-22 14:16:36 +0000 |
|---|---|---|
| committer | Matthew Somerville <matthew@mysociety.org> | 2010-12-22 14:16:36 +0000 |
| commit | 5cf8f25ae1bb343ac49c86c69d028a6d12c55ef2 (patch) | |
| tree | d0ce422d1a86145579f6910ab566c67fe8b11b86 /db | |
| parent | 01ef2083512c6ba0b5525f2b0687e28d694c5eaa (diff) | |
RSS feed returning only open or fixed problems.
Diffstat (limited to 'db')
| -rw-r--r-- | db/alert_types.sql | 11 |
1 files changed, 11 insertions, 0 deletions
diff --git a/db/alert_types.sql b/db/alert_types.sql index d605d8e65..82a8c71f8 100644 --- a/db/alert_types.sql +++ b/db/alert_types.sql @@ -42,6 +42,17 @@ values ('local_problems', '', '', 'problem_find_nearby(?, ?, ?) as nearby,problem', 'nearby.problem_id = problem.id and problem.state in (''confirmed'', ''fixed'')', 'created desc', '{{title}}, {{confirmed}}', '/report/{{id}}', '{{detail}}', 'alert-problem-nearby'); +-- New problems around a location +insert into alert_type +(ref, head_sql_query, head_table, + head_title, head_link, head_description, + item_table, item_where, item_order, + item_title, item_link, item_description, template) +values ('local_problems_state', '', '', + 'New local problems on FixMyStreet', '/', 'The latest local problems reported by users', + 'problem_find_nearby(?, ?, ?) as nearby,problem', 'nearby.problem_id = problem.id and problem.state in (?)', 'created desc', + '{{title}}, {{confirmed}}', '/report/{{id}}', '{{detail}}', 'alert-problem-nearby'); + -- New problems sent to a particular council insert into alert_type (ref, head_sql_query, head_table, |