jro_apps/redmine Commit - r15369:9f9232381ab6

Filter on issue ID with between/lesser/greater operator does not work (#23596)....

Jean-Philippe Lang -

r15369:9f9232381ab6

parent child

Context file:

r15369:9f9232381ab6

app/models/issue_query.rb +9 -4

               end
               def sql_for_issue_id_field(field, operator, value)
-                ids = value.first.to_s.scan(/\d+/).map(&:to_i).join(",")
+                if operator == "="
-                if ids.present?
+                  # accepts a comma separated list of ids
-                  "#{Issue.table_name}.id IN (#{ids})"
+                  ids = value.first.to_s.scan(/\d+/).map(&:to_i)
+                  if ids.present?
+                    "#{Issue.table_name}.id IN (#{ids.join(",")})"
+                  else
+                    "1=0"
+                  end
                 else
-                  "1=0"
+                  sql_for_field("id", operator, value, Issue.table_name, "id")
                 end
               end

test/unit/query_test.rb +9 -1

                 assert_equal 2, issues.first.id
               end
-              def test_operator_is_on_integer_should_accept_comma_separated_values
+              def test_operator_is_on_issue_id_should_accept_comma_separated_values
                 query = IssueQuery.new(:name => '_')
                 query.add_filter("issue_id", '=', ['1,3'])
                 issues = find_issues_with_query(query)
                 assert_equal [1,3], issues.map(&:id).sort
               end
+              def test_operator_between_on_issue_id_should_return_range
+                query = IssueQuery.new(:name => '_')
+                query.add_filter("issue_id", '><', ['2','3'])
+                issues = find_issues_with_query(query)
+                assert_equal 2, issues.size
+                assert_equal [2,3], issues.map(&:id).sort
+              end
               def test_operator_is_on_integer_custom_field
                 f = IssueCustomField.create!(:name => 'filter', :field_format => 'int', :is_for_all => true, :is_filter => true, :trackers => Tracker.all)
                 CustomValue.create!(:custom_field => f, :customized => Issue.find(1), :value => '7')

General Comments 0

You need to be logged in to leave comments. Login now

No TODOs yet

	Repositories
g s	Goto summary page
g c	Goto changelog page
g f	Goto files page
g F	Goto files page with file search activated
g p	Goto pull requests page
g o	Goto repository settings
g O	Goto repository access permissions settings
t s	Toggle sidebar on some pages