aboutsummaryrefslogtreecommitdiffstats
path: root/perllib/FixMyStreet/DB
diff options
context:
space:
mode:
Diffstat (limited to 'perllib/FixMyStreet/DB')
-rw-r--r--perllib/FixMyStreet/DB/Result/Problem.pm10
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' },
}
);
}