diff options
Diffstat (limited to 'perllib/FixMyStreet/DB/Result/Problem.pm')
-rw-r--r-- | perllib/FixMyStreet/DB/Result/Problem.pm | 12 |
1 files changed, 7 insertions, 5 deletions
diff --git a/perllib/FixMyStreet/DB/Result/Problem.pm b/perllib/FixMyStreet/DB/Result/Problem.pm index 855732f83..69dc17e44 100644 --- a/perllib/FixMyStreet/DB/Result/Problem.pm +++ b/perllib/FixMyStreet/DB/Result/Problem.pm @@ -658,13 +658,15 @@ order of title. =cut sub response_templates { - my $problem = shift; - return $problem->result_source->schema->resultset('ResponseTemplate')->search( + my $self = shift; + return $self->result_source->schema->resultset('ResponseTemplate')->search( { - body_id => $problem->bodies_str_ids + 'me.body_id' => $self->bodies_str_ids, + 'contact.category' => [ $self->category, undef ], }, { - order_by => 'title' + order_by => 'title', + join => { 'contact_response_templates' => 'contact' }, } ); } @@ -681,7 +683,7 @@ sub response_priorities { return $self->result_source->schema->resultset('ResponsePriority')->search( { 'me.body_id' => $self->bodies_str_ids, - 'contact.category' => $self->category, + 'contact.category' => [ $self->category, undef ], }, { order_by => 'name', |