From c05a91c924a13ff1085e9996194d30e4270e2cbd Mon Sep 17 00:00:00 2001
From: yashodha <yashodha.chaku@webaccessglobal.com>
Date: Mon, 5 Jan 2015 11:55:02 +0530
Subject: [PATCH] CRM-14461: note fields not handled properly for components
 during export

----------------------------------------
* CRM-14461: Participant notes incomplete when exporting participants
  https://issues.civicrm.org/jira/browse/CRM-14461
---
 CRM/Export/BAO/Export.php | 3 +++
 1 file changed, 3 insertions(+)

diff --git a/CRM/Export/BAO/Export.php b/CRM/Export/BAO/Export.php
index aaac8a0a9e..564d95de03 100644
--- a/CRM/Export/BAO/Export.php
+++ b/CRM/Export/BAO/Export.php
@@ -1378,6 +1378,9 @@ INSERT INTO {$componentTable} SELECT distinct gc.contact_id FROM civicrm_group_c
           $sqlColumns[$fieldName] = "$fieldName varchar(16)";
         }
       }
+      elseif (substr($fieldName, -5, 5) == '_note') {
+        $sqlColumns[$fieldName] = "$fieldName text";
+      }
       else {
         $changeFields = array(
           'groups',
-- 
2.25.1