Feature #6332
closed"OR" filter and not only "AND" filter
Added by Alexander F over 14 years ago. Updated over 2 years ago.
0%
Description
Hi,
I can currently set quite complex filters on the issue list with redmine.
The only problem is that the filters have a default behavior of logical "AND" between them and I can't set it to "OR"/other logical operators.
Related issues
Updated by Jean-Baptiste Barth over 14 years ago
It would add too much complexity to the model. I don't see any known website that offers such a possibility. Any other opinion about that ?
Updated by Jon Lumpkin about 14 years ago
+1 for this issue.
Many of the other issue tracking systems do actually allow this, including:- Jira
- Trac
- BugTracker.net
I was going to try fogbugz, but I couldn't find a totally open demo install. I don't mind trying other alternatives too, but wasn't sure which others were large enough or had open demos. I just went through the list of other sites we looked at before using Redmine.
Jira and BugTracker.net both allow you to use 'OR' basically by allowing multiple selections. They either use a listbox or other method for you to choose more than one option.
Trac on the other hand has another field that allows you to say if its an 'or' or 'and' comparison.
This shouldn't change any models too much, all you would be doing is letting the user build more of the query that they are already making.
Updated by Jon Lumpkin about 14 years ago
+1 for this issue.
Many of the other issue tracking systems do actually allow this, including:- Jira
- Trac
- BugTracker.net
I was going to try fogbugz, but I couldn't find a totally open demo install. I don't mind trying other alternatives too, but wasn't sure which others were large enough or had open demos. I just went through the list of other sites we looked at before using Redmine.
Jira and BugTracker.net both allow you to use 'OR' basically by allowing multiple selections. They either use a listbox or other method for you to choose more than one option.
Trac on the other hand has another field that allows you to say if its an 'or' or 'and' comparison.
This shouldn't change any models too much, all you would be doing is letting the user build more of the query that they are already making.
We would really like this feature because then you could do queries like 'I want to see all issues I am assigned to and watching'.
Updated by Jon Lumpkin about 14 years ago
Could someone remove comment #2? I forgot the redmine.org installation didn't let you edit your comments.
Updated by Frank Helk about 14 years ago
+1
I'd like such options, too ... at least I would appreciate to have list based fields (i.e. status, category, priority, versions) to have multiple selection lists (OR connected) ... i.e. [Status = New OR Assigned]
On the other hand it would be nice if I could set more than one filter on a text field - i.e. [Subject contains "tracker"] AND [Subject contains "field"]. That would allow more detailled searches in long ticket lists.
A more revolutionary approach: Give two ways of definig filters. The current way and a formula based one. In the formula based filter there could be a text field for a search formula like [subject~"tracker" and (status=assigned or status=new) and subject!~"project"] meaning "subject contains tracker but not project and status is assigned or new".
Updated by Paolo Sulprizio about 14 years ago
Frank Helk wrote:
On the other hand it would be nice if I could set more than one filter on a text field - i.e. [Subject contains "tracker"] AND [Subject contains "field"]. That would allow more detailled searches in long ticket lists.
there is my feature req #1140 ;)
Updated by Stéphane Gourichon over 12 years ago
Updated by Daniel Albuschat over 12 years ago
+1
I'd like to create a filter that shows tickets that are scheduled for today (call it "Today's tickets"). But the filter should additionally include tickets with the priority "Critical", regardless of when the tickets are scheduled (critical tickets don't need scheduling).
Updated by Gerd Müller about 12 years ago
+1
I'd like to list all tickets that are assigned to me OR I'm observing.
Updated by Jeremy Payn almost 12 years ago
I agree that there needs to hopefully be greater filter ability. I am needing to set a filter that includes items assigned to me or items authored by me. I cannot currently do this. What ends up filtering down are the items that I authored and assigned to myself. I would also like the email notifications by the projects that I choose to include only that, and not other projects that someone assigned me as a watcher on. Thanks.
Updated by Christian Ziegelt almost 12 years ago
+1 !
Since redmine ist realy the best system out there I would realy realy like to stay with redmine.
Unfortunately this is a kind of KO criteria for us.
Updated by Anonymous almost 12 years ago
+1
Also it should be possible to set brackets to refine custom queries
Updated by Gurvan Le Dromaguet almost 12 years ago
+1
Isn't this a duplicate of 4939 ?
Updated by Daniel Felix almost 12 years ago
- Category set to Issues
- Status changed from New to Closed
- Resolution set to Duplicate
Gurvan Le Dromaguet wrote:
Isn't this a duplicate of 4939 ?
Yes. Your right. Currently they are just in relation. I will set this issue as duplicate of #4939 and add the other relation to it.
Updated by Toshi MARUYAMA over 10 years ago
- Related to deleted (Feature #10999: Ticket list filter: More flexible filter conditions)
Updated by Vladimir Perepechenko almost 8 years ago
Yes, OR for filters is really needed.
Updated by Lionel Vanacker over 7 years ago
I need too to do filter with logical "OR". How can I do ?
Updated by Roman Yagodin about 7 years ago
+1 for this.
It could be great to allow filters with multiple conditions by same field (e.g. status is "open" AND status is not feedback) also.
Updated by Albrecht Dreß over 6 years ago
+1 for this!
This worked just fine with trac (which has many other drawbacks compared to Redmine, though), by using either the UI or by defining the sql queries directly. The latter would be a nice option, too, as it might allow to address more complex use cases.
Typical use case for my organization (note the parentheses…): ticket is open AND (I am assignee OR I am author)
Updated by Erik S. almost 3 years ago
+1 for this but more logical operators for filters in general also multiple conditions for the same field.
How can this basic functionality not have been prioritized after all these years (11 years!)?
I'm trying to create filters to create a simple Eisenhower Matrix: [[https://todoist.com/productivity-methods/eisenhower-matrix]] with the help of
tagsbut I fail since cannot create the condition:
tag is "Important" AND tag is "Urgent"for a logical AND. But I can only create a logical OR.
Please prioritize!
Updated by Igor M over 2 years ago
Erik S. wrote:
+1 for this but more logical operators for filters in general also multiple conditions for the same field.
How can this basic functionality not have been prioritized after all these years (11 years!)?
Please prioritize!
+1 !!!!!