comparison of two custom fields (number fields)

[Dominik M.]

Hello,

I need to compare two custom fields' values. If the transition is to be successful then field's A numeric value must be equal or greater than a value present in field B.

So far I can see that only dates can be compared - please advise me if it's possible to perform comparisons between numeric fields and if yes, where is it present (I can't find anything adeqaute under Conditions nor Validators...)

Many thanks,

Dominik Maciejewski

[philubert]

Using Adaptavist's ScriptRunner, you can do this in JQL:

issueFunction in expression("","field1 > field2")

[Suporte OAT]

Doesn´t work to Jira Cloud.

Any suggestion?

[Maarten Cautreels]

Hi Dominik, 

Unfortunately, by default this is not support but luckily there's a very cool addon that can help you get these type of things done. 

You can find more details on a similar question that has already been answered before: https://community.atlassian.com/t5/Questions/JQL-JIRA-query-for-custom-field-being-equal-to-two-other-custom/qaq-p/44808

Best, 

Maarten

[Dominik M.]

Maarten,

Many thanks for confirming this to me, too bad I've spent nearly 2 days trying to do this via Option ID comparison in transition's Conditions tab...

P.S. What's the addon name? Is it Power Scripts for JIRA (formerly JJUPIN)?

Regards,

Dominik