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

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.


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 




2017-08-26 13:07


Menú_246.png (2,702 bytes)   
Menú_246.png (2,702 bytes)   

Related Changesets

MantisBT: master d886a795

2017-08-26 08:42:48


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

Issue History

Date Modified Username Field Change
2017-08-26 13:07 cproensa New Issue
2017-08-26 13:07 cproensa File Added: Menú_246.png
2017-08-26 13:07 cproensa Summary Numeric custom fields aren't sorted correctly on distinct values list => Filter selection for numeric custom fields aren't sorted correctly on distinct values list
2017-08-26 13:11 cproensa Relationship added related to 0006872
2017-08-26 13:13 cproensa Status new => assigned
2017-08-26 13:13 cproensa Assigned To => cproensa
2017-10-07 12:45 dregad Changeset attached => MantisBT master d886a795
2017-10-07 12:45 cproensa Status assigned => resolved
2017-10-07 12:45 cproensa Resolution open => fixed
2017-10-07 12:45 cproensa Fixed in Version => 2.7.0
2017-10-07 13:32 atrol Target Version => 2.7.0
2017-10-08 11:50 cproensa Relationship added child of 0023443
2017-10-08 23:52 vboctor Status resolved => closed