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!

[Hannes Obweger - JXL for Jira · Accepted solution]

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 @Hannes Obweger - JXL for Jira 

It was helpful!

[Marc Koppelaar - Devoteam]

Hi @yirang Im 

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

[yirang Im]

Thank you!