Defect #38055

Inconsistent results for filtering issues containing custom fields

Added by Ko Nagase about 1 month ago. Updated about 1 month ago.

Status:ConfirmedStart date:
Priority:NormalDue date:
Assignee:-% Done:


Target version:Candidate for next major release
Resolution: Affected version:5.0.3


How to reproduce

  1. Prepare a working environment
    $ RAILS_ENV=development bin/rails db:fixtures:load
  2. Start Redmine and display http://localhost:3000/issues without login.
  3. From filters, check off "Status" then add "Tracker" filter with operator "is" and value "Bug" and "Support request" (Because "Searchable field" custom field is only available in those trackers).
    =>The result is 8 issues.
  4. Select "Searchable field" from "Add filter", select operator "contains" and value 125.
    =>The result is 2 issues.
  5. Change the operator to "doesn't contain" and apply it.
    =>The result is 1 issues.

The total number of cases in No.4 and No.5 is 3 which does not match the total number of issues (6)

Expected behavior

The sum of the results of "contains" and "doesn't contain" matches the total number of issues.
If the condition is "is" and "is not", the sum of the results matches the total number of issues.

Possible Causes

The filter ignore issues which the custom field "Searchable filter" is not present when the filter is "doesn't contain".

Solution patch

To make the behavior consistent with "is" and "is not", the "doesn't contain" result should include the number of issues that do not have the custom field.

We (@tomokosimi, @tohosaku, @ishikawa999 and @sanak) created the attachment patch file which solves this issue by modifying "not contains" operator SQL only when searching custom field values, so reviewing this is helpful.

2022-12-17-issue-filter.patch Magnifier (1.69 KB) Ko Nagase, 2022-12-17 08:53


#1 Updated by Ko Nagase about 1 month ago

Sorry, I missed to attache the patch, so I upload it in this post.

#2 Updated by Go MAEDA about 1 month ago

  • Status changed from New to Confirmed

#3 Updated by Go MAEDA about 1 month ago

  • Target version set to Candidate for next major release

Also available in: Atom PDF