How to compare two custom fields using JQL function

I am looking to compare 2 customfields of same datatype. Any help on this approach

1 answer

This widget could not be displayed.

Natively within Jira there is not a way to do this.   However you might be able to leverage a plugin in Jira in order to search like this. 

I have found a few other threads that appear to indicate that SQL for Jira might be able to be used in this manner.

And another thread that indicates you might be able to use Scriptrunner in order to make a comparison like this.

Thanks for your suggestion Andrew.

I am looking for comparison using script runner. Also I would like to know what classes needs to be extended for this?

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Wednesday in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

146 views 2 0
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you