CiviCRM Community Forums (archive)

We have a few uses for hook_civicrm_contactListQuery, filtering which contacts show up for contact reference custom fields.  As of our upgrade to 4.2.19, it seems it is no longer being called.  None of our custom fields are getting filtered properly.

Here is an example the basic code we use, I don't see why it would not work.  Is this a bug?

function fei_civicrm_contactListQuery( &$query, $name, $context, $id )
{

  // Connect the hook to the Contact Reference custom field using the field ID
  // Field ID 29: Team Coordinator for Team Events
  if ( $context == 'customfield' && $id == 29 ) {

    // Construct the query to select only the contacts we want
    // The query must return two columns - data (what is shown in the field display), and contact id
    $query = "SELECT
      case when c.nick_name is not null then concat(c.nick_name, ' ', c.last_name) else c.display_name end as data
      , c.id
      FROM civicrm_contact c
      INNER JOIN civicrm_group_contact cg
        ON c.id = cg.contact_id
      WHERE (concat(last_name, ', ', ifnull(nick_name, first_name)) LIKE '%$name%'
             OR
             sort_name LIKE '%$name%'
            )
      AND   cg.group_id IN ( 10 ) -- This must match the ID of the FEI Staff: Home Office group
      AND   cg.status = 'Added'
      AND   c.is_deleted = 0
      ORDER BY c.sort_name
      LIMIT 50";
  } // end if context


} // end function


We upgraded from 3.3.6, so I'm not sure where this could have occurred.  Any work-around to get it going?  Should I file a bug?

I was under the impression 4.2 was LTS.  Doesn't a bug like this count in that?

I would try to go to 4.4, but it seems there are some database structure changes and we have a lot of custom code to work through.  I was hoping we can get 4.2 working so we can stay there until the one developer (me) has enough time to work through higher versions with more changes and potential surprises like this one.

Hi Eileen,
So I upgraded to 4.5 on my dev box (same config as production), and the issue still persists.  The hook is not getting called.  What do you recommend now?

Yes, my module has other hooks, including additional Tabs for Contacts and buildForm hooks for Event Registration forms, and those all work fine.  It is only the contactListQuery that is not being called for custom fields.  If it helps, the custom fields this is failing on are for Events (when you create an event), not sure that matters, though.

As I mentioned, it works fine in 3.3.6, and I believe my code is rather straightforward.  I didn't test on any versions other than 4.2 and 4.5, both of which don't work.  I cannot test this on the demo, of course, so I can't verify outside my environments.  But I can tell you this happens on both our production instance (which we had to roll back from 4.2 to 3.3.6 because of issues like this) and my dev box.

Also, I recall searching these forums, and I found at least one other post mentioning the same issue.  No one replied to that post and I wasn't sure which version it was on, so I created a new post.

Please let me know how I should proceed.

Well, could you maybe give me a place to even start debugging?  Where is the hook supposed to be called from?  I see CRM/Utils/Hook.php, but that just seems to define each function.  What does the calling of the hook when a custom field shows up on a form?

Some help would be appreciated, I don't know the core code like you all do, I just create customizations like hooks per your documentation (which was working well till recently).