Defect #25077
closed
Issue description filter's 'none' operator does not match issues with blank descriptions
0%
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
Related issues
Updated by Mischa The Evil over 8 years ago
- Related to Feature #1159: Allow issue description to be searchable as a filter added
Updated by Marius BĂLTEANU over 8 years ago
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.
Updated by Marius BĂLTEANU over 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.
Updated by Marius BĂLTEANU over 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?
Updated by Jean-Philippe Lang over 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.
Updated by Marius BĂLTEANU over 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.
Updated by Jean-Philippe Lang over 8 years ago
- Status changed from New to Closed
- Assignee set to Jean-Philippe Lang
- Resolution set to Fixed
Thanks Marius, the patch is committed.
Updated by Pavel Rosický about 8 years ago
it should also be fixed on '*' operator like on custom values, don't you think?
Updated by Marius BĂLTEANU about 8 years ago
Pavel Rosický wrote:
it should also be fixed on '*' operator like on custom values, don't you think?
Can you open a new issue, please?
Updated by Go MAEDA over 1 year ago
- Related to Defect #39991: Fix "any" operator for text filters to exclude empty text values added