Feature #6180

Searchable custom fields do not provide adequate operators

Added by Tom Rochette over 7 years ago. Updated over 6 years ago.

Status:ClosedStart date:2010-08-20
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Custom fields
Target version:1.3.0
Resolution:Fixed

Description

Using an integer custom field (called Affected revision, searchable) as a filter in the issues list should provide me with integer operators such as =, !=, >, <, >=, <=, ...

Instead, I am provided with string comparison operators which does not make much sense. It would also be interesting to be able to use range operator to determine a range of values. This is certainly required for both float and integer custom fields.

Installation details:
Database version - MySQL 5.1.49
Ruby version - ruby 1.9.1p378 (2010-01-10 revision 26273) [i686-linux]
Rails version - 2.3.5
Redmine version - SVN revision 4010

redmine_bug.png (12.2 KB) Tom Rochette, 2010-08-20 01:48

EXAMPLE_MISSING_FIELD.diff Magnifier (537 Bytes) Tom Rochette, 2010-08-20 03:45


Related issues

Related to Redmine - Defect #8709: Issue filter select wrong , format type Integer Closed 2011-06-29

Associated revisions

Revision 6213
Added by Jean-Philippe Lang over 6 years ago

Numeric operators for custom fields in query filters (#6180).

Revision 6216
Added by Jean-Philippe Lang over 6 years ago

Fixes "less than", "greater than" filters on custom fields with postgres (#6180).

Revision 6217
Added by Jean-Philippe Lang over 6 years ago

Adds "between" operator for numeric filters (#6180).

History

#1 Updated by Tom Rochette over 7 years ago

Here included is an example of a fix for the integer values. This is by no mean complete but it seems to fix the displaying and filtering using correct operators.

#2 Updated by Eric Davis about 7 years ago

  • Tracker changed from Defect to Feature

#3 Updated by Eric Davis about 7 years ago

  • Priority changed from High to Normal

#4 Updated by Etienne Massip over 6 years ago

  • Target version set to Candidate for next major release

#5 Updated by Jean-Philippe Lang over 6 years ago

  • Target version changed from Candidate for next major release to 1.3.0

#6 Updated by Jean-Philippe Lang over 6 years ago

  • Status changed from New to Closed
  • Resolution set to Fixed

Also available in: Atom PDF