nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

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

Accepted answers

Alexey Matveev

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

All comments

Alexey Matveev

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")

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jql