From 6070a62d8bc202d586353697a0af8ce5700cdfe1 Mon Sep 17 00:00:00 2001 From: CiviCRM Date: Wed, 4 Jun 2014 17:07:48 +0530 Subject: [PATCH] CRM-14107 fix for Full Text Search ---------------------------------------- * CRM-14107: Implement Previous / Next navigation on contact summary pages when accessed from a custom search https://issues.civicrm.org/jira/browse/CRM-14107 --- CRM/Contact/Form/Search/Custom/FullText.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) diff --git a/CRM/Contact/Form/Search/Custom/FullText.php b/CRM/Contact/Form/Search/Custom/FullText.php index 1801ceb71a..59e293b3e5 100644 --- a/CRM/Contact/Form/Search/Custom/FullText.php +++ b/CRM/Contact/Form/Search/Custom/FullText.php @@ -965,8 +965,8 @@ FROM {$this->_tableName} contact_a case 'Contact': $sql = " INSERT INTO {$this->_tableName} -( contact_id, sort_name, display_name, table_name ) -SELECT c.id, c.sort_name, c.display_name, 'Contact' +( id, contact_id, sort_name, display_name, table_name ) +SELECT c.id, ct.entity_id, c.sort_name, c.display_name, 'Contact' FROM {$this->_entityIDTableName} ct INNER JOIN civicrm_contact c ON ct.entity_id = c.id {$this->_limitDetailClause} -- 2.25.1