One of our users reported a strange phenomenon when using search builder. I recreated this on the demo site.

When searching for activity type = Meeting I don't get results:

Search Builder doesnt work with =

When searching for activity type like "Meeting" I get (correct) results: Search builder works with like

I have similar problems with activity status. Using 'like' works in some cases, but I can't use '=' or 'in'.

Can anyone reproduce this behaviour?


I was able to reproduce the behavior; it seems like a bug, can you post a bug report here: https://issues.civicrm.org/jira/browse/CRM/?selectedTab=com.atlassian.jira.jira-projects-plugin:summary-panel

  • Thanks, it certainly looks like one. I was just surprised no one noticed this before us. I'll report the bug asap.
    – tosca
    Oct 21 '15 at 12:03

Well as per my recent fixes in Search Builder, atleast I have changed the column Title to clarify whether a element expects a string value or int. Like in this particular case you will have Activity Type( expects string value as 'Label') and Activity Type ID(integer value as activity_type_id), but that fix was partial. So the error is occurring due to faulty select element which you used to select value against '=' operator as it is in ('id' => 'label') format and the expected format would be ('label' => 'label'). And the underlying fix it needs will be major.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.