From 4e474ab587f5d56da4917a1f8e38b73520df5b61 Mon Sep 17 00:00:00 2001
From: Brian Shaughnessy <brian@lcdservices.biz>
Date: Sat, 1 Apr 2017 22:11:37 -0400
Subject: [PATCH] CRM-20369 mailing clicks report

---
 CRM/Report/Form/Mailing/Clicks.php | 21 ++++++++++++++++++---
 1 file changed, 18 insertions(+), 3 deletions(-)

diff --git a/CRM/Report/Form/Mailing/Clicks.php b/CRM/Report/Form/Mailing/Clicks.php
index 580f3069c4..73c3e30017 100644
--- a/CRM/Report/Form/Mailing/Clicks.php
+++ b/CRM/Report/Form/Mailing/Clicks.php
@@ -112,7 +112,7 @@ class CRM_Report_Form_Mailing_Clicks extends CRM_Report_Form {
       'fields' => array(
         'mailing_name' => array(
           'name' => 'name',
-          'title' => ts('Mailing'),
+          'title' => ts('Mailing Name'),
           'default' => TRUE,
         ),
         'mailing_name_alias' => array(
@@ -120,21 +120,36 @@ class CRM_Report_Form_Mailing_Clicks extends CRM_Report_Form {
           'required' => TRUE,
           'no_display' => TRUE,
         ),
+        'mailing_subject' => array(
+          'name' => 'subject',
+          'title' => ts('Mailing Subject'),
+          'default' => true,
+        ),
       ),
       'filters' => array(
         'mailing_id' => array(
           'name' => 'id',
-          'title' => ts('Mailing'),
+          'title' => ts('Mailing Name'),
           'operatorType' => CRM_Report_Form::OP_MULTISELECT,
           'type' => CRM_Utils_Type::T_INT,
           'options' => CRM_Mailing_BAO_Mailing::getMailingsList(),
           'operator' => 'like',
         ),
+        'mailing_subject' => array(
+          'name' => 'subject',
+          'title' => ts('Mailing Subject'),
+          'type'=> CRM_Utils_Type::T_STRING,
+          'operator' => 'like',
+        ),
       ),
       'order_bys' => array(
         'mailing_name' => array(
           'name' => 'name',
-          'title' => ts('Mailing'),
+          'title' => ts('Mailing Name'),
+        ),
+        'mailing_subject' => array(
+          'name' => 'subject',
+          'title' => ts('Mailing Subject')
         ),
       ),
       'grouping' => 'mailing-fields',
-- 
2.25.1