From 9fab06f35ac4a086b8c6fafbcba2ed95e4be241e Mon Sep 17 00:00:00 2001 From: Edsel Date: Tue, 25 Nov 2014 16:34:18 +0530 Subject: [PATCH] CRM-15642 Modified use location widget to include supplemental addresses 1 & 2 ---------------------------------------- * CRM-15642: Unable to select similar locations in Event Location tab https://issues.civicrm.org/jira/browse/CRM-15642 --- CRM/Event/BAO/Event.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Event/BAO/Event.php b/CRM/Event/BAO/Event.php index f73f6ece15..02bf41019c 100644 --- a/CRM/Event/BAO/Event.php +++ b/CRM/Event/BAO/Event.php @@ -1817,7 +1817,7 @@ WHERE id = $cfID $events = array(); $query = " -SELECT CONCAT_WS(' :: ' , ca.name, ca.street_address, ca.city, sp.name) title, ce.loc_block_id +SELECT CONCAT_WS(' :: ' , ca.name, ca.street_address, ca.city, sp.name, ca.supplemental_address_1, ca.supplemental_address_2) title, ce.loc_block_id FROM civicrm_event ce INNER JOIN civicrm_loc_block lb ON ce.loc_block_id = lb.id INNER JOIN civicrm_address ca ON lb.address_id = ca.id -- 2.25.1