From 593e0d0b2ffbc66ad24fccd89845d4bfb5ec0f4f Mon Sep 17 00:00:00 2001
From: Edsel <edsel.lopez@jmaconsulting.biz>
Date: Thu, 9 Mar 2017 19:29:36 +0530
Subject: [PATCH] CRM-20025 Added check to restrict test contributions from
 appearing

----------------------------------------
* CRM-20025: DB Error on email task for advanced search for contributions
  https://issues.civicrm.org/jira/browse/CRM-20025
---
 CRM/Contribute/Form/Task.php | 16 ++++++++++++++++
 1 file changed, 16 insertions(+)

diff --git a/CRM/Contribute/Form/Task.php b/CRM/Contribute/Form/Task.php
index fdbcbd18d0..3f1a4e50f8 100644
--- a/CRM/Contribute/Form/Task.php
+++ b/CRM/Contribute/Form/Task.php
@@ -115,6 +115,22 @@ class CRM_Contribute_Form_Task extends CRM_Core_Form {
     }
     else {
       $queryParams = $form->get('queryParams');
+      $isTest = FALSE;
+      foreach ($queryParams as $fields) {
+        if ($fields[0] == 'contribution_test') {
+          $isTest = TRUE;
+          break;
+        }
+      }
+      if (!$isTest) {
+        $queryParams[] = array(
+          'contribution_test',
+          '=',
+          0,
+          0,
+          0,
+        );
+      }
       $returnProperties = array('contribution_id' => 1);
       $sortOrder = $sortCol = NULL;
       if ($form->get(CRM_Utils_Sort::SORT_ORDER)) {
-- 
2.25.1