Merge pull request #10165 from jitendrapurohit/mailingfix

[civicrm-core.git] / tools / scripts / solr / createSolrXML.php

diff --git a/tools/scripts/solr/createSolrXML.php b/tools/scripts/solr/createSolrXML.php
index 8dbcb1f630423bc3669368ba954bf6e9efe8168d..b42ef1745f47f9c4d1866eb9a5b34bd27e09077d 100644 (file)
--- a/tools/scripts/solr/createSolrXML.php
+++ b/tools/scripts/solr/createSolrXML.php
@@ -198,6 +198,7 @@ function getLocationInfo(&$contactIDs, &$values) {
 SELECT
   l.entity_id as contact_id, l.name as location_name,
   a.street_address, a.supplemental_address_1, a.supplemental_address_2,
+  a.supplemental_address_3,
   a.city, a.postal_code,
   co.name as county, s.name as state, c.name as country,
   e.email, p.phone, i.name as im
@@ -215,7 +216,7 @@ WHERE l.entity_table = 'civicrm_contact'
 ";
 
   $fields = array('location_name', 'street_address', 'supplemental_address_1',
-    'supplemental_address_2', 'city', 'postal_code', 'county', 'state',
+    'supplemental_address_2', 'supplemental_address_3', 'city', 'postal_code', 'county', 'state',
     'country', 'email', 'phone', 'im',
   );
   $dao = CRM_Core_DAO::executeQuery($sql);