Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Customized filter does not work properly

Leila K I'm New Here Jan 06, 2022

project = <Project_Name> AND component = <Component_Name" AND status in ("To Do", "In Progress", "In Backlog", Acceptance, Pending, "Ready for Review", "ready for work") AND fixVersion in (2.0.1, 2.0.0) OR affectedVersion in ("Text/1.0.0", "text/1.1.0", "text/1.2.0", "text/1.3.0", "text/1.4.0", "text/1.4.1")

 The search result is giving me wrong information  for component and status  

I tried to substitute the Status with a different definition 

1-status not in (Closed, Resolved, "In Integration", "Scheduled for Integration")

2-status != "Closed" => this also trigger search result to find other project !!

3- resolution = Unresolved 

 

However, adding status again at the end of search  seems to give me correct result 

project = <Project_Name> AND component = <Component_Name" AND status in ("To Do", "In Progress", "In Backlog", Acceptance, Pending, "Ready for Review", "ready for work") AND fixVersion in (2.0.1, 2.0.0) OR affectedVersion in ("Text/1.0.0", "text/1.1.0", "text/1.2.0", "text/1.3.0", "text/1.4.0", "text/1.4.1") AND status in ("To Do", "In Progress", "In Backlog", Acceptance, Pending, "Ready for Review", "ready for work")

 

Seems there is something wrong or I am missing a point here since you have more experience could you please advise me why the search result behave like this?   

 

Thanks in Advance,

LK

1 answer

1 accepted

1 vote
Answer accepted

Hi @Leila K 

Welcome to Community!

You have syntax mistake. If I understand your problkem correctly it should be:

project = <Project_Name> AND component = <Component_Name" AND status in ("To Do", "In Progress", "In Backlog", Acceptance, Pending, "Ready for Review", "ready for work") AND (fixVersion in (2.0.1, 2.0.0) OR affectedVersion in ("Text/1.0.0", "text/1.1.0", "text/1.2.0", "text/1.3.0", "text/1.4.0", "text/1.4.1"))

 

From Atlassian documentation: The AND keyword takes precedence over other keywords, because it groups clauses together, essentially turning them into one combined clause.

It means that in your query Jira try to search this way:

project = <Project_Name> AND component = <Component_Name" AND status in ("To Do", "In Progress", "In Backlog", Acceptance, Pending, "Ready for Review", "ready for work") AND fixVersion in (2.0.1, 2.0.0)

OR

affectedVersion in ("Text/1.0.0", "text/1.1.0", "text/1.2.0", "text/1.3.0", "text/1.4.0", "text/1.4.1")

Regards,

Piotr

Leila K I'm New Here Jan 06, 2022

Hi Piotr, Super, Thanks for prompt response and your kind support. It is working now. 

Best Regards,

Leila 

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Published in Jira Software

👋 Looking for 15-20 volunteers to test Atlassian training content

Hi everyone! Are you interested in beta testing Atlassian University’s newest (unreleased!) training course? We’re looking for 15-20 volunteers to test our newest training course, Basic reporting...

555 views 20 25
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you