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
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
Hi Piotr, Super, Thanks for prompt response and your kind support. It is working now.
Best Regards,
Leila
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.