JIRA Structure Formula help

[balaji ramachandran]

 This formula works like what I want 

 with hSeconds    = 3600000:

with tOrignalEst = SUM {IF JQL { issueFunction in linkedIssuesOfAllRecursive("Key='ABC-12666'") and status != Canceled } :

                                                OriginalEstimate 

                                                }:

Round(tOrignalEst /hSeconds,0)

But I don’t want to hardcode the issue key, I want to pass that as a variable, as given below, and I am not sure with the syntax. It is throwing me all sorts of errors. Can y'all help? Please

 with hSeconds    = 3600000:

with iKey  = “ABC-12666”:

with tOrignalEst = SUM {IF JQL { issueFunction in linkedIssuesOfAllRecursive("Key='" + ikey + "'\"") and status != Canceled } :

                                                OriginalEstimate 

                                                }:

Round(tOrignalEst /hSeconds,0)

Thanks for your help and I really appreciate it.

[Nicholas Ellis _ALM Works_]

Hi Balaji,

Unfortunately you cannot inject variables into the JQL{} functions query string. Here is the relevant documentation.  The reason it works this way is for performance reasons.  In a large structure of 10k+ issues each with their own JQL query it becomes a very resource intensive operation to complete.

Cheers,
Nick