The value created in the lookup table cannot be calculated in the JQL condition of if

koutarou ishibashi

I want to calculate the value created in the lookup table in the JQL condition of if.
I would like to make the if condition calculated as follows, but is it not possible to calculate with the if JQL table?
{{#=}} {{done.get("A")}} - {{open.get("A")}} {{/}} > -1 and {{done.get("A")}} > 0

Bill Sheboy

Hi @koutarou ishibashi 

Your expression is both incorrectly using conditional logic and trying to combine that with a math expression in a way the rule cannot process.

Instead try using the inline version of those operations.  (I am assuming your lookup table values are text, and so have added asNumber for conversions.)

{{#if(and(done.get("A").asNumber.minus(open.get("A").asNumber).gt(-1), done.get("A").asNumber.gt(0)))}}do something{{/}}

As a tip...try building up logic like this piece by piece, writing the results to the audit log.  That will help confirm the expression works as you expect.

Kind regards,
Bill