Feature #10999
openTicket list filter: More flexible filter conditions
0%
Description
I have not found any workaround on that by now ...
As far as I understand it, the filter conditions for the ticket list (text fields) filter on an exact phrase in any case. With that behaviour, I can't filter for tickets containing i.e. 2 words at random positions in the field. Normally I would circumvent that by just adding another filter on the same field, but unfortunately that is blocked - only one condition per field is allowed.
I would suggest to either
- allow multiple filter conditions on the same field, connected by "AND", or
- implement some kind of optional pattern search like RegEx, or
- (preferred) implement search pattern interpretation rules for text fields, like a choice of
"exact phrase / all words (AND) / any word (OR) / RegEx" as drop down list.
Related issues
Updated by Daniel Albuschat almost 12 years ago
The first suggestion is related to #1140.
Updated by @ go2null over 10 years ago
+1
Would also like to see it for (multi-select) lists:any of
(replacesis
)none of
(replacesis not
)all of
not all of
is empty
(replacesnone
)is not empty
(replacesany
)
Updated by @ go2null over 10 years ago
Note: you can currently filter text fields thus:field contains value1%value2
Obvious caveat: value1
must be before value2
in field
.
Updated by Toshi MARUYAMA about 10 years ago
- Related to deleted (Feature #6332: "OR" filter and not only "AND" filter)
Updated by txemi M almost 9 years ago
+1.
I would suggest allowing to bypass UI filter limitations accepting a query expressed in query language.
With this, next goals would be achieved:
- Not adding complexity to current user interface, no need to develop complex user interface to express complex queries.
- Easy to develop if query language matchs internal query ruby on rails languages (I am not a ruby developer, I am not sure how queries are expressed internally, but if so, sure the patch to achieve this would be very small).
- Queries would not be limited to user interface, offering all features availables at backend.
- Any user with some development hability could express any query.
At front end option to use query language instead of current form should be offered to users.
Any ruby on rails developer could throw an opinion on this, is it feasible?
Updated by Hide MATSUTANI over 8 years ago
+1
I think it's better if we could choose in the 'list' formatted custom fields.
@ go2null wrote:
+1
Would also like to see it for (multi-select) lists:
any of
(replacesis
)none of
(replacesis not
)all of
not all of
is empty
(replacesnone
)is not empty
(replacesany
)
Updated by Toshi MARUYAMA about 8 years ago
- Category changed from UI to Issues filter
Updated by Toshi MARUYAMA about 8 years ago
- Has duplicate Feature #23216: Issues List, Enhanced Filtering - Allowing Multiple Queries & "OR"-type constraints added
Updated by Jean Louis about 8 years ago
+10
I don't find plugin that do this, I try _query plugin but it's between 2 different filters.
I want to search (any of
) words in only issues description filter, for example: word1 OR word2
@ go2null wrote:
Would also like to see it for (multi-select) lists:
any of
(replacesis
)none of
(replacesis not
)all of
not all of
is empty
(replacesnone
)is not empty
(replacesany
)
Updated by Quan VN about 8 years ago
Dear Jean Louis
Thank you for your note. I see your point. For the list type fields, this is built-in as far as I understand. For text field in general, I will try to see if I can implement something like your suggestion.
Quan
Jean Louis wrote:
+10
I don't find plugin that do this, I try _query plugin but it's between 2 different filters.
I want to search (any of
) words in only issues description filter, for example: word1 OR word2@ go2null wrote:
Would also like to see it for (multi-select) lists:
any of
(replacesis
)none of
(replacesis not
)all of
not all of
is empty
(replacesnone
)is not empty
(replacesany
)
Updated by Quan VN about 8 years ago
Update on July 24
Jean Lacoste Louis: Thank you again for your suggestion. I have implemented the two operators on the text field allowing to do boolean search within a text field, so you can search something like:
(word1 OR word 2) AND word3 AND NOT word4.
Please help me to test it here. (it is updated version of _query)
http://www.redmine.org/plugins/boolean_query
Jean Louis wrote:
+10
I don't find plugin that do this, I try _query plugin but it's between 2 different filters.
I want to search (any of
) words in only issues description filter, for example: word1 OR word2@ go2null wrote:
Would also like to see it for (multi-select) lists:
any of
(replacesis
)none of
(replacesis not
)all of
not all of
is empty
(replacesnone
)is not empty
(replacesany
)
Updated by Andreas F almost 8 years ago
Any news about this topic? We need the possibility to use and/or conditions. Also we need the possibility to filter project tags ...
A must have :)
Updated by Frank Helk almost 8 years ago
Doesn't look like there are any news on this. I'm still waiting for it, with some constantly nagging users in my back :(
BTW: I don't think that this functionality is a candidate for a plugin ... it should definitely be part of the Redmine core package.
Updated by Frank Helk about 7 years ago
Hmmm - I see constantly dripping in "+1" from people who would like to have that too, but the issue is active for 5 years now w/o anybody feeling the urge to implement it.
Any hint how to draw a bit attention on this ?
Updated by Yu AOKI almost 7 years ago
@Quan VN
Thank you for boolean_query plugin.
When I tested it on redmine 3.1.0, I've got a NoMethodError on 'sql_contains', so I needed to modify line 175 on query_patch2.rb as follows:
(This is just FYI, since I am not exactly sure if 3.1.0 is under support, nor how I can contribute on this plugin, such as pull request.)
[before mod] sql << "(" + sql_contains("#{db_table}.#{db_field}", term, match) + ")" [after mod] sql << "(" + "LOWER(#{db_table}.#{db_field}) LIKE '%#{self.class.connection.quote_string(term.to_s.downcase)}%'" + ")"
Thanks.
Quan VN wrote:
Update on July 24
Jean Lacoste Louis: Thank you again for your suggestion. I have implemented the two operators on the text field allowing to do boolean search within a text field, so you can search something like:(word1 OR word 2) AND word3 AND NOT word4.
Please help me to test it here. (it is updated version of _query)
http://www.redmine.org/plugins/boolean_query
Jean Louis wrote:
+10
I don't find plugin that do this, I try _query plugin but it's between 2 different filters.
I want to search (any of
) words in only issues description filter, for example: word1 OR word2@ go2null wrote:
Would also like to see it for (multi-select) lists:
any of
(replacesis
)none of
(replacesis not
)all of
not all of
is empty
(replacesnone
)is not empty
(replacesany
)
Updated by Frank Helk almost 7 years ago
Just an additional opinion:
Creating some plugin is nice, but I presume that plugins are a measure for very special problems like interfacing to other software and tasks not close to Redmine's core functionality. Unfortunately then features requested here affect (tune up ? dope ? ;-) a very core part of Redmine, and I'd prefer them to be realized where they belong: In the core of Redmine.
Besides of that plugins tend to get unsupported with time moving on, and every new Redmine release bears the risk of breaking the plugin. I wouldn't recommend to expose such a core-near feature to that vulnerability.
Updated by Roman Yagodin almost 7 years ago
+1
Could not create a simple "Issues created or closed today" query without OR!