Details
-
Type:
Bug
-
Status: In Progress
-
Priority:
Major
-
Resolution: Unresolved
-
Affects Version/s: 4.6.18
-
Fix Version/s: None
-
Component/s: CiviCRM Search, Core CiviCRM
-
Labels:None
-
Versioning Impact:Patch (backwards-compatible bug fixes)
-
Documentation Required?:None
-
Funding Source:Contributed Code
-
Payment Status:Estimate Sent
Description
When searching for custom fields of type 'checkbox' and 'multiselect' in Find Activities, it returns more than the expected results. So if looking for a option with value 1 it also returns options with value 11, 12, 13 etc.
Please try replication steps to see the issue in detail.
Replication Steps:
1) Create a Custom field for Activity with "Data Type - Alphanumeric" and "Field Type - Checkbox"
2) Create around 15 multiple choice options as shown here:
3) Then create a few activities with this custom field as follows.
Activity 1 - with Option 1 (aaa)
Activity 2 - with Option 11 (kkk)
Activity 3 - with Option 14 (nnn)
Activity 4 - with Option 15 (ooo)
4) Then in Find Activities, search for 'aaa' under the custom field.
Expected Result - should return only one result which is Activity 1 which has 'aaa' as the custom field
Actual Result - returns all 4 activities.
