CiviCRM Community Forums (archive)

*

News:

Have a question about CiviCRM?
Get it answered quickly at the new
CiviCRM Stack Exchange Q+A site

This forum was archived on 25 November 2017. Learn more.
How to get involved.
What to do if you think you've found a bug.



  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Search builder and custom field with multiple options
Pages: [1]

Author Topic: Search builder and custom field with multiple options  (Read 568 times)

jaapjansma

  • I post frequently
  • ***
  • Posts: 247
  • Karma: 9
    • CiviCoop
  • CiviCRM version: 4.4.2
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5.4
Search builder and custom field with multiple options
April 28, 2014, 08:43:57 am
Hey,

I have a custom field which is a mutiple checklist with options.
I just created a search builder based on this field
E.g.
Person -> Custom Field -> In -> Option 2 (OVL)

But this does not show all the contacts and on the result page it shows a query like RLIKE OVL (OVL is the value of the option).
If I change the query builder to the operator Rexexp the value is set to OVL and all the contacts are found.
So it looks like the operator IN does not work correctly on a multiple checkbox custom field.

Is my observation right? If so I would file on issue for this.
Developer at Edeveloper / CiviCoop

jaapjansma

  • I post frequently
  • ***
  • Posts: 247
  • Karma: 9
    • CiviCoop
  • CiviCRM version: 4.4.2
  • CMS version: Drupal 7
  • MySQL version: 5
  • PHP version: 5.4
Re: Search builder and custom field with multiple options
April 29, 2014, 01:36:13 am
I have created an issue for this.

https://issues.civicrm.org/jira/browse/CRM-14563

The fix can be found at https://github.com/civicrm/civicrm-core/pull/3015
Developer at Edeveloper / CiviCoop

Pages: [1]
  • CiviCRM Community Forums (archive) »
  • Old sections (read-only, deprecated) »
  • Support »
  • Using CiviCRM »
  • Using Core CiviCRM Functions (Moderator: Yashodha Chaku) »
  • Search builder and custom field with multiple options

This forum was archived on 2017-11-26.