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; } } }

Using comparison JQL between two fields

yirang Im

Hi, Sir.

I want to find issues by using comparison operators.

The (custom) fields are both numbers, so my JQL is basically like "A(field)" > "B(field)"

but it doesn't work.

It only works when comparing two things between one of the fields and a number, for example "A(field)"<1000.

what should I put more to make it work? here "A(field)" > "B(field)"

Thank you for your support!

Accepted answers

Hannes Obweger - JXL for Jira

Hi @yirang Im

this isn't possible in plain JQL. What you could do is to use Jira Automation to calculate

"A(field)" > "B(field)"

for your issues and write the result into a custom field, and then use the custom field in your JQL query.

Hope this helps,

Best,

Hannes

All comments

Marc -Devoteam-

Hi @yirang Im

There is no such option in JQL, to compare fields.

Hannes Obweger - JXL for Jira

Hi @yirang Im

this isn't possible in plain JQL. What you could do is to use Jira Automation to calculate

"A(field)" > "B(field)"

for your issues and write the result into a custom field, and then use the custom field in your JQL query.

Hope this helps,

Best,

Hannes

yirang Im

Thank you!

yirang Im

Thank you @Hannes Obweger - JXL for Jira

It was helpful!

Welcome!

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

Quick Links

Find more posts tagged with

cloud

jira-service-management-cloud

jira-service-management