Kepler CF SIL Script to compute time difference not working properly

[Gabriel MOSCALU]

Hi,

I created a CF using com.keplerrominfo.jira.plugins.keplercf plugin. It is supposed to compute a simple difference between 2 other CFs : start & end.

Code:

interval i ;
if (isNotNull(customfield_10613) and isNotNull(customfield_10612) ) {
// if (customfield_10613>0) {
     i = customfield_10613 - customfield_10612;
     return (string)(i["TOMILLIS"] / 600000) + "m"; // will return "17m" as string
} else {
    // i = currentDate() - created;
    // return i;
    return 0;
}

Where:

10612 = Actual Issue start time

 10613 = Actual issue end time

The code above does not return the proper result  

Actual Issue start time:	10/Nov/15 1:34 PM
Actual issue end time:	10/Nov/15 2:54 PM
Actual issue duration:	8m

Expected result would be "80m", not "8m".

Am I doing something wrong, or is there an issue with the plugin?

Versions:

JIRA: v6.4.8#64023-sha1:bab6790

Service Desk: 2.5.9

Kepler CF: 3.0.3

CF Searcher: I tried using both Interval & Free text searcher with similar results.

Would someone have any hints?

Thanks

Gabriel

[Silviu Burcea · Accepted solution]

Hi Gabriel,

return (string)(i["TOMILLIS"] / 600000) + "m";

You are dividing by 600.000, but it should be 60.000 ( 1000 for millis to seconds, 60 from seconds to minutes ). The extra 0 is causing the off by 10x error.

Hope this helps,

Silviu