diff options
Diffstat (limited to 'perllib/FixMyStreet/DB')
-rw-r--r-- | perllib/FixMyStreet/DB/Result/Problem.pm | 10 |
1 files changed, 6 insertions, 4 deletions
diff --git a/perllib/FixMyStreet/DB/Result/Problem.pm b/perllib/FixMyStreet/DB/Result/Problem.pm index 855732f83..ae713ef2d 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' }, } ); } |