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

When searching in range on custom integer field for multiple records, field is ignored and all records are returned

    Details

    • Type: Bug
    • Status: Done/Fixed
    • Priority: Major
    • Resolution: Duplicate
    • Affects Version/s: 3.3.1
    • Fix Version/s: 3.4.alpha
    • Component/s: None
    • Labels:
      None

      Description

      Here's what I did to reproduce:

      • Administer CiviCRM >> Custom Data >> Add Set of Custom Fields
      • Set Name -> CUSTOMSET
      • Used For -> Individual, - Any -
      • Used For -> Individual, - Any -
      • Does this Custom Field Set allow multiple records? -> Yes
      • Display Style -> Tab
      • Save
      • Custom Fields
      • Field Label -> OPTIONS
      • Data and Input Field Type -> Alphanumeric, Advanced Multi-Select
      • Option Type -> Create a new set of options
      • Multiple Choice Options -> Opt 1, op1
      • Multiple Choice Options -> Opt 2, op2
      • Multiple Choice Options -> Opt 3, op3
      • Required? -> Yes
      • Is this Field Searchable? -> Yes
      • Save and New
      • Field Label -> YEAR
      • Data and Input Field Type -> Number, Text
      • Required? -> Yes
      • Is this Field Searchable? -> Yes
      • Search by Range? -> Yes
      • Save
      • View Contact >> CONTACT1 >> CUSTOMSET >> Edit CUSTOMSET
      • OPTIONS -> Opt 1, Opt 2
      • YEAR -> 2001
      • Add another CUSTOMSET record
      • OPTIONS -> Opt 1
      • YEAR -> 2002
      • Save
      • View Contact >> CONTACT2 >> CUSTOMSET >> Edit CUSTOMSET
      • OPTIONS -> Opt 1, Opt 3
      • YEAR -> 2005
      • Save
      • View Contact >> CONTACT3 >> CUSTOMSET >> Edit CUSTOMSET
      • OPTIONS -> Opt 2
      • YEAR -> 2003
      • Save
      • - - -
      • Advanced Search >> Custom Fields >> CUSTOMSET
      • OPTIONS -> Opt 1
      • YEAR -> 2000, 2003
      • Search

      Expected Results: CONTACT1
      Actual Results: CONTACT1, CONTACT 2

      • - - -
      • Advanced Search >> Custom Fields >> CUSTOMSET
      • YEAR -> 2002, 2003
      • Search

      Expected Results: CONTACT1, CONTACT 3
      Actual Results: [All Contacts]

      There is no easy work-around that I can find.

        Attachments

          Activity

            People

            • Assignee:
              lobo Donald A. Lobo
              Reporter:
              mbogosian Matt
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: