diff options
| author | Matthew Somerville <matthew@mysociety.org> | 2019-06-26 11:25:36 +0100 |
|---|---|---|
| committer | Matthew Somerville <matthew@mysociety.org> | 2019-06-26 13:03:06 +0100 |
| commit | 09c7f9d765e2a58c3e74eee0ed03612d19ee7f9f (patch) | |
| tree | 378822f700570d4b3a0de9bd4cb1aede659c1bf2 /perllib/FixMyStreet/Script/Questionnaires.pm | |
| parent | 62b19194a099e6e5ac1140aea0ed42744cdff786 (diff) | |
Turn on quote_names.
Diffstat (limited to 'perllib/FixMyStreet/Script/Questionnaires.pm')
| -rw-r--r-- | perllib/FixMyStreet/Script/Questionnaires.pm | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/perllib/FixMyStreet/Script/Questionnaires.pm b/perllib/FixMyStreet/Script/Questionnaires.pm index aab4b9b75..5db66ff7c 100644 --- a/perllib/FixMyStreet/Script/Questionnaires.pm +++ b/perllib/FixMyStreet/Script/Questionnaires.pm @@ -33,8 +33,8 @@ sub send_questionnaires_period { }; $q_params->{'-or'} = [ - '(select max(whensent) from questionnaire where me.id=problem_id)' => undef, - '(select max(whenanswered) from questionnaire where me.id=problem_id)' => { '<', \"current_timestamp - '$period'::interval" } + \'(select max(whensent) from questionnaire where me.id=problem_id) IS NULL', + \"(select max(whenanswered) from questionnaire where me.id=problem_id) < current_timestamp - '$period'::interval", ]; my $unsent = FixMyStreet::DB->resultset('Problem')->search( $q_params, { |