Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL query

Sydnie Andreassi
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
January 17, 2019

I have the following query inn jira

project = GE AND resolution = Unresolved AND component in ("Projects ", "Sales Content") ORDER BY priority DESC, updated DESC

 

However I want it to only show results for components that have both Project AND Sales Content. Would you be able to tell me how to update the query to yield that result?

2 answers

1 vote
Rafael Pinto Sperafico
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 17, 2019

Hi @Sydnie Andreassi,

When using IN, you are searching for "Projects" OR "Sales Content". Instead, based on what you have described, you would like to replace the:

component in ("Projects ", "Sales Content")

with

(component = "Projects " AND component = "Sales Content")

More information on Advanced Search documentation.

Kind regards,

Rafael

1 vote
Jakub Hanak
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 17, 2019

Hello @Sydnie Andreassi,

Try to use ....and component = ("component1"  AND "component2"). This should work. 

Best regards,

Jakub 

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events