Creating a JQL query

[Radhika Tk]

Hi,

I need help in figuring out the query for combining the custom field and a system field.

Scenario

I have a Custom field, "Customer" and another field "Labels" defined in JIRA

Both the fields belong to the same project.

Now i want to combine these two fields while writing a query to get me the unresolved issues.

Here goes: 

Project = A AND resolution = Unresolved 
AND customer in ("customer 1", "customer 2") AND labels = "label 1"

I do not get the result that i need. Hope I have made myself clear.

Looking forward to responses,

Radhika

[Alexey Matveev · Accepted solution]

Hello,

I can not see a condition for an issue to be unresolved. I think it should be like this:

Project = A AND customer in ("customer 1", "customer 2") AND labels = "label 1" and resolution is empty

[Radhika Tk]

Project = A AND resolution = Unresolved 
AND customer in ("customer 1", "customer 2") AND labels = "label 1"

[Radhika Tk]

Project = A AND resolution = Unresolved 
AND customer in ("customer 1", "customer 2")

This query alone gives me 74 issues

 Project = A AND resolution = Unresolved 
AND labels = "label 1"

This query alone gives me 8 issues

Now when I combine both, there are 0 issues  

Project = A AND resolution = Unresolved 
AND customer in ("customer 1", "customer 2") AND labels = "label 1"

[Alexey Matveev]

It means that there are no issues like this. If you want to combine resultls of two JQL quereis, you should join both JQL queries with OR

Project = A AND resolution = Unresolved AND(customer in ("customer 1", "customer 2") 
OR labels = "label 1")

[Radhika Tk]

Thanks Alexey, that helped!

[Alexey Matveev]

You are welcome!