From 51527a6e20fdd37a165f02e9a71a04f591ca7147 Mon Sep 17 00:00:00 2001
From: Coleman Watts <coleman@civicrm.org>
Date: Thu, 26 Mar 2015 12:51:15 -0400
Subject: [PATCH] CRM-16155 - Limit past mailing selection

---
 CRM/Mailing/Info.php | 18 ++++++++++++++----
 1 file changed, 14 insertions(+), 4 deletions(-)

diff --git a/CRM/Mailing/Info.php b/CRM/Mailing/Info.php
index 273372de0e..14e9ccee7a 100644
--- a/CRM/Mailing/Info.php
+++ b/CRM/Mailing/Info.php
@@ -95,14 +95,24 @@ class CRM_Mailing_Info extends CRM_Core_Component_Info {
     $session = CRM_Core_Session::singleton();
     $contactID = $session->get('userID');
 
+    // Get past mailings
+    // CRM-16155 - Limit to a reasonable number
+    $civiMails = civicrm_api3('Mailing', 'get', array(
+      'is_completed' => 1,
+      'mailing_type' => array('IN' => array('standalone', 'winner')),
+      'return' => array('id', 'name', 'scheduled_date'),
+      'sequential' => 1,
+      'options' => array(
+        'limit' => 500,
+        'sort' => 'is_archived asc, scheduled_date desc',
+      )
+    ));
+    // Generic params
     $params = array(
       'options' => array('limit' => 0),
       'sequential' => 1,
     );
-    $civiMails = civicrm_api3('Mailing', 'get', $params + array(
-      'is_completed' => 1,
-      'return' => array('id', 'name', 'scheduled_date'),
-    ));
+    
     $campNames = civicrm_api3('Campaign', 'get', $params + array(
       'is_active' => 1,
       'return' => 'title',
-- 
2.25.1