Can I use more Custom Filter at Once ?

[Giuseppe Guglielmino]

Hi there

I think my question is quite simple

I created this custom filters

Filter 1
status="In progress"

Filter 2
status="Completed and Committed"

Filter 3
status="QA"

In my board, they worked perfectly as single filter but when I try to combine them like checking at the same time Filter 1 and Filter 2, no tickets are showed in my board

[Jack Brickey · Accepted solution]

Hi @Giuseppe Guglielmino , welcome to the Community. The issue here is that the filters operate as an "and" function not an "or". So you are asking to show all issues where the status is: "In progress" AND "Completed and Committed" AND "QA". What type of project are you using here? Can you share a screenshot? If it is company managed then you could create a quick filter to achieve your query.

[Natalia_Kovalchuk_SaaSJet_]

Hi!

It seems your filters operate independently instead of functioning as intended. The problem most probably results from the board's approach to managing multiple filter conditions.

I can propose you to do the following:

Option 1: In case your board applies filters with an AND condition, no tickets will match because a ticket can't have two statuses at once. For example, if you use a filter like this status="In progress" AND status="Completed and Committed", then they cannot be seen at once.

You need to use OR instead. For example, status IN ("In progress", "Completed and Committed").

Option 2: Some boards apply filters independently rather than in combination. Rather than choosing multiple filters, you can create a distinctive new filter that combines your two essential conditions.

My team also developed the Issue History for Jira add-on. The add-on enables you to set up dynamic custom filters rather than using separate filters that may create conflicts. You can apply multiple status filters without needing to create advanced JQL queries.

[Giuseppe Guglielmino]

Hi Natalia

I wouldn't like to create one filter for each combination of ticket status (ex status="In Progress" AND "QA", status="QA" AND "Approved", etc....).

My goal is rather, to create a filter system, composed by all the board tickets status.
I want give the user the chance to use it as a single filter (Checking just one status among the ones available) or combine them as much as he would like (Checkin two or more status).

[Vishal Biyani]

@Giuseppe Guglielmino 

Filter 1 and Filter 2 should have OR condition and not AND condition for it to work.

Can you share the JQL that you have used?

[Vishal Biyani]

@Giuseppe Guglielmino 

Can you go to filters->view all issues. Then you will see a screen like this

on the right side, you will see JQL. Click on that.

Now you can manually type the query and put a OR between two filters.

see if this works for you

[Giuseppe Guglielmino]

Thanks for all your answer

Here below you can find the screenshot you asked for.

I tried to insert "And" operator either at the beginning and end of the JQL expression, but it didn't allow to do that.

Maybe I need a different approach.

Do you have any advice about it ? 

[Michael Wohlgemuth]

Hello!

One jira issue can only have one status at a time. So the filter combination of:

 status = "In Progress" AND status = "Completed and Committed" 

will never find any issues.

If you wish to see issues in both status, you should create a filter showing both:

 status = "In Progress" OR status = "Completed and Committed" 

or alternatively:

status in ("In Progress", "Completed and Committed")