Uploaded image for project: 'CiviCRM'
  1. CiviCRM
  2. CRM-3560

Usability Improvement: Allow displayed value for custom fields in Search Builder


    • Type: Improvement
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Won't Fix
    • Affects Version/s: 2.1, 2.2.0
    • Fix Version/s: 4.3.0
    • Component/s: Core CiviCRM
    • Labels:


      For performance reasons it is common practice to set option values for custom fields to be integers while having the display values as strings. However this configuration makes using the Search Builder with custom fields a real pain since you need to go to the Custom Field admin section to lookup the integer that you need before you do your search.

      Furthermore this isn't obvious unless you know how the custom field is setup, you read the Search Builder documentation in fine detail, and you have permissions to visit the Custom Fields admin section.

      In order to eliminate these extra steps the input could be validated before the query is built. First check if the user input is a valid option value for this field, if not then check if it is a valid display value, if so then use the matching option value.


        1. civicrm_search_builder.diff
          75 kB
          dave hansen-lange
        2. civicrm_search_builder.diff
          73 kB
          dave hansen-lange
        3. civicrm_search_builder.diff
          72 kB
          dave hansen-lange



            • Assignee:
              lobo Donald A. Lobo
              dalin dave hansen-lange
            • Votes:
              0 Vote for this issue
              1 Start watching this issue


              • Created: