Feature #4939

List of tasks filtered as OR and not AND

Added by Alain V. over 7 years ago. Updated 3 months ago.

Status:NewStart date:2010-02-26
Priority:NormalDue date:
Assignee:-% Done:

0%

Category:Issues filter
Target version:-
Resolution:

Description

Hello

Up to now in the list of task you can filter upon some values but the list of filters are
List of tasks that has
filter1=value1 AND filter2=value2 AND filter3=value3

I think it could be interesting to have the possibility of
List of tasks that has
filter1=value1 OR filter2=value2 OR filter3=value3

Do you think it is possible? thank you

Redmine using OR.zip (11.5 KB) Quan VN, 2013-09-19 11:45

_query.zip - Plugins version, better than the patch version above (3.56 KB) Quan VN, 2015-11-20 02:49


Related issues

Related to Redmine - Feature #10999: Ticket list filter: More flexible filter conditions New
Duplicated by Redmine - Feature #7641: Issue filter with OR semantic additional to current AND s... Closed 2011-02-17
Duplicated by Redmine - Feature #12970: Implement the "OR" operator in queries Closed
Duplicated by Redmine - Feature #6332: "OR" filter and not only "AND" filter Closed 2010-09-08
Duplicated by Redmine - Feature #10421: Filter with OR conditions Closed
Duplicated by Redmine - Feature #21532: Adding OR and XOR request to REST API and issue filters Closed
Duplicated by Redmine - Feature #23211: Issue filter menu should have different logical operators... Closed
Duplicated by Redmine - Feature #23216: Issues List, Enhanced Filtering - Allowing Multiple Queri... Closed

History

#1 Updated by Jean-Philippe Lang over 7 years ago

  • Category set to Issues

#2 Updated by Andrew Sherman over 7 years ago

+1. This would be useful for some filters I have tried to make as well.

#3 Updated by Jeremy Walker over 7 years ago

+1 I would love it if Redmine had this functionality. Perhaps the easiest/most powerful way to implement this would be to make a way for users to create filters out of combinations of other filters. In other words, if I could define filters A, B, and C, and then say something like "Give me all the issues that are in A OR B, but not in C", I could get any issue list I could ever want. And that would be awesome.

#4 Updated by Jeremy Walker over 7 years ago

Jeremy Walker wrote:

+1 I would love it if Redmine had this functionality. Perhaps the easiest/most powerful way to implement this would be to make a way for users to create filter sets out of combinations of other filter sets. In other words, if I could define filter sets A, B, and C, and then say something like "Give me all the issues that are in A OR B, but not in C", I could get any issue list I could ever want. And that would be awesome.

#5 Updated by Alain V. about 7 years ago

Any progress on this subject guys? ;o)

#6 Updated by Matthias Neubert over 6 years ago

+1
Thats nearly what I ment with #7641, but I'd like to combine AND and OR freely.

e.g. A AND B OR C AND D

should list all issues which fullfill both, A and B

plus the issue which fillfill both, C and D

Basically it should be read like disjunctive normal form

#7 Updated by Matthias Neubert over 6 years ago

also this could be interesting when one wants to list all issues
assigned to me, and also all which aren't assigned yet.

for this feature a filtercriteria must be usable more than one time

or other solution: the list of possible assignees contains a special element "Not assigned" at the top of the list, so one can select (by multiple selection) me and "Not assigned"

#8 Updated by Gurvan Le Dromaguet over 4 years ago

It looks like it is implemented in "Trac": http://trac.edgewall.org/query, see the "OR" at the bottom right of the filters box

#9 Updated by Francesco V over 4 years ago

Gurvan Le Dromaguet wrote:

It looks like it is implemented in "Trac": http://trac.edgewall.org/query, see the "OR" at the bottom right of the filters box

I like it

#10 Updated by Daniel Felix over 4 years ago

Yes this would be a good improvement. It won't be easy but a really cool addition to the current filter-system.

#11 Updated by Christian Baus over 4 years ago

+1

any workaround here? we need a filter like "is autor or observer"

#12 Updated by Dani Leni about 4 years ago

+1

Need Assignee or Watcher.

#14 Updated by Quan VN about 4 years ago

Here is my quick and dirty solution. I am not a RoR developer and this is my very first attempt so that I can use Redmine for my job.
I hope that someone can make this into a full plugin. If you have any idea or find problem, please let me know. I will see if I can do anything. Thanks

#15 Updated by Christian Baus about 4 years ago

Thanks for your patch! i look forward to implement that in our redmine!!

#16 Updated by Zbynek Drlik almost 4 years ago

+1

#17 Updated by Lu Su over 3 years ago

+1

#18 Updated by Antoine Pichon over 3 years ago

+1 (thanks for your excellent work)

#19 Updated by Toshi MARUYAMA over 3 years ago

#20 Updated by Toshi MARUYAMA over 3 years ago

#21 Updated by Toshi MARUYAMA over 3 years ago

#22 Updated by James H over 3 years ago

+1

#23 Updated by Sebastian Paluch almost 3 years ago

Matthias Neubert wrote:

+1
Thats nearly what I ment with #7641, but I'd like to combine AND and OR freely.

e.g. A AND B OR C AND D

should list all issues which fullfill both, A and B

plus the issue which fillfill both, C and D

Basically it should be read like disjunctive normal form

+1

so important feature and no progress for 5 years :(

#24 Updated by Jan Niggemann (redmine.org team member) almost 3 years ago

so important feature and no progress for 5 years :(

We only have 2 programmers working in their spare time, plus contributions from a few other volunteers.

If you send patches that apply cleanly against current trunk (together with tests) we'd happily test and apply those.

#25 Updated by Istvan Heckl about 2 years ago

+1

#26 Updated by Quan VN about 2 years ago

I have made this patch into a plugins here (with some improvement). It works with redmine 2.6.x and 3.1.1 or less. Please use the plugin instead of this patch

http://www.redmine.org/plugins/zquery

#27 Updated by Jānis Elmeris almost 2 years ago

+1

#28 Updated by Quan VN almost 2 years ago

#29 Updated by Toshi MARUYAMA almost 2 years ago

  • Duplicated by Feature #21532: Adding OR and XOR request to REST API and issue filters added

#30 Updated by Fred B over 1 year ago

What is the difference between zquery and _query?

Did someone tested one with Redmine 2.4?

#31 Updated by Quan VN over 1 year ago

Fred B wrote:

What is the difference between zquery and _query?

Did someone tested one with Redmine 2.4?

Dear Fred
1. They are the same but I renamed zquery to _query so it is loaded first. _query is now the "official" version :-) (I have replace zquery attachment with _query but the name is still in the link)
2. I think it should work with 2.3 upward since I developed it based on 2.3 version
Quan

#32 Updated by Toshi MARUYAMA over 1 year ago

  • Duplicated by Feature #23211: Issue filter menu should have different logical operators like "AND", "OR", ... added

#33 Updated by Toshi MARUYAMA over 1 year ago

  • Category changed from Issues to Issues filter

#34 Updated by Toshi MARUYAMA over 1 year ago

  • Duplicated by Feature #23216: Issues List, Enhanced Filtering - Allowing Multiple Queries & "OR"-type constraints added

#35 Updated by JW Fuchs over 1 year ago

+1

#36 Updated by Iwadara I 5 months ago

+1

#37 Updated by Reto Stamm 4 months ago

+1

#38 Updated by Yuuki NARA 4 months ago

+1

#39 Updated by Santiago Torres 3 months ago

+1

Also available in: Atom PDF