MantisBT: master-1.2.x b03397ad

Author Committer Branch Timestamp Parent
dhx dhx master-1.2.x 2010-03-04 07:49 master-1.2.x b7b9537d
Affected Issues  0011561: Filtering for custom field types multilist and checkbox does not work
Changeset

Fix 0011561: Filtering fails for multi-select custom field types

When attempting to filter bugs based on multi-select custom fields, some
bugs are not returned. This is due to multi-select custom field values
being stored as a string in the database with a vertical pipe character
being used as a delimiter between values. We can't just check for:

LIKE '%|value|%'

We also need to check for:

LIKE 'value|%'
LIKE '%|value'
= 'value'

To catch all possible cases of a value being stored within a
multi-select custom field string.

mod - core/database_api.php Diff File
mod - core/filter_api.php Diff File