View Issue Details

IDProjectCategoryView StatusLast Update
0023265mantisbtcustom fieldspublic2017-10-08 23:52
Reportercproensa Assigned Tocproensa  
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Product Version2.6.0 
Target Version2.7.0Fixed in Version2.7.0 
Summary0023265: Filter selection for numeric custom fields aren't sorted correctly on distinct values list
Description

When custom fields with a number based type (numeric, float) are populated on filter form, the values are not sorted numerically.

Attached example of a float custom field, where 100 is placed before 3

TagsNo tags attached.
Attached Files
MenĂº_246.png (2,702 bytes)   
MenĂº_246.png (2,702 bytes)   

Relationships

related to 0006872 closedcproensa Sort of custom fields does not use data type 
child of 0023443 closedcproensa Fixes related to custom fields on filters, columns and visibility 

Activities

Related Changesets

MantisBT: master d886a795

2017-08-26 04:42

cproensa

Committer: dregad


Details Diff
Cast custom fields distinct values

Cast values for number based custom fields, when retrieving distinct
values. This allows:
- The values are sorted numerically on the list
- The values returned match what will be shown in the custom field, in
case of type mismatch. For example, when having text stored in a
numeric field.

Fixes: 0023265, 0023266
Affected Issues
0023265, 0023266
mod - core/custom_field_api.php Diff File