From 66cf862ead41a319ddbff3ca408e7dbd01e92bf3 Mon Sep 17 00:00:00 2001 From: Eileen McNaughton Date: Fri, 20 Jun 2014 15:43:56 +1200 Subject: [PATCH] CRM-14887 further fix on table --- CRM/Contact/BAO/Query.php | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) diff --git a/CRM/Contact/BAO/Query.php b/CRM/Contact/BAO/Query.php index 42389ce8e2..eb8a2e1f7e 100644 --- a/CRM/Contact/BAO/Query.php +++ b/CRM/Contact/BAO/Query.php @@ -2548,7 +2548,7 @@ class CRM_Contact_BAO_Query { //we have a join on an address table - possibly in conjunction with search builder - CRM-14263 $parts = explode('-', $name); $locationID = array_search($parts[0], CRM_Core_BAO_Address::buildOptions('location_type_id', 'get', array('name' => $parts[0]))); - $from .= " $side JOIN civicrm_address `{$name}` ON ( contact_a.id = `{$name}`.contact_id ) and location_type_id = $locationID "; + $from .= " $side JOIN civicrm_address `{$name}` ON ( contact_a.id = `{$name}`.contact_id ) and `{$name}`.location_type_id = $locationID "; } else { $from .= CRM_Core_Component::from($name, $mode, $side); -- 2.25.1