Defect #25077: Issue description filter's 'none' operator does not match issues with blank descriptions - Redmine

Actions

Copy link

Defect #25077

closed

Issue description filter's 'none' operator does not match issues with blank descriptions

Added by Mischa The Evil almost 8 years ago. Updated over 7 years ago.

Status:

Closed

Priority:

Normal

Assignee:

Jean-Philippe Lang

Category:

Issues filter

Target version:

3.4.0

Start date:

Due date:

% Done:

Estimated time:

Resolution:

Fixed

Affected version:

Description

Use of the issue description filter with the 'none' operator always returns nothing as it does not include issues with blank descriptions. I think most users expect that issues with blank descriptions are going to be matched when using the filter with the 'none' operator, as such the actual results may be unexpected.

Currently, the 'none' operator only matches issues that are assigned to trackers that have the description field disabled (which is not yet possible with the core, see #25052).

Files

Download all files

set_blank_decriptions_to_nil.patch (2.06 KB) set_blank_decriptions_to_nil.patch		Marius BĂLTEANU, 2017-02-18 20:17
rm_25077_fix_query_filter_after_none_for_text_and_string_column.patch (1.84 KB) rm_25077_fix_query_filter_after_none_for_text_and_string_column.patch		Marius BĂLTEANU, 2017-03-06 08:35

Related issues

Actions

Copy link

Updated by Mischa The Evil almost 8 years ago

Related to Feature #1159: Allow issue description to be searchable as a filter added

Actions

Copy link

Updated by Marius BĂLTEANU almost 8 years ago

File set_blank_decriptions_to_nil.patch set_blank_decriptions_to_nil.patch added

From my point of view, there are 2 ways to fix this issue:

1. Set description to nil for all new issues with blank description and migrate all existing issues that have description blank to nil.
2. Change the query for description field in order to check for description is nil or description equals with empty string;

I made a patch that implements the first solution because I think in this way we fix the root cause. The second solution is just an workaround.

If there is any side effect of my solution, I can make a patch with the second fix.

Actions

Copy link

Updated by Marius BĂLTEANU almost 8 years ago

Mischa The Evil, do you have any feedback regarding the patch? I'm thinking now that if setting the description blank instead of null is a rails behaviour, we should not change this and I should create a patch with the second solution.

Actions

Copy link

Updated by Marius BĂLTEANU almost 8 years ago

Jean-Philippe Lang, how do you think we should solve this issue? With the solution from my patch or we should modify the query?

Actions

Copy link

Updated by Jean-Philippe Lang almost 8 years ago

Marius BALTEANU wrote:

Jean-Philippe Lang, how do you think we should solve this issue? With the solution from my patch or we should modify the query?

We should be able to modify the query for text/string filters without much trouble.

Actions

Copy link

Updated by Marius BĂLTEANU almost 8 years ago

File rm_25077_fix_query_filter_after_none_for_text_and_string_column.patch rm_25077_fix_query_filter_after_none_for_text_and_string_column.patch added

Thanks for your feedback, Jean-Philippe Lang. I've attached a new patch that fixes the issue for text (like description) and string fields. For custom fields, the issue was already fixed.

Actions

Copy link