I'm using the following formula
<!-- @@Formula:
if (issue.get("customfield_17937").getTime() == null) return null;
if (issue.get("customfield_17938").getTime() == null) return null;
(issue.get("customfield_17937").getTime() - issue.get("customfield_17938").getTime()) / 1000 / 3600
-->
It shows on screen and all but my logs are full with the following message
IssueIndexer:thread-3 ERROR user001 395x16093x1 zbxffj 10.244.35.64,127.0.0.1 /secure/admin/IndexReIndex.jspa [innovalog.jmcf.fields.CalculatedNumberField] CalculatedNumberField: error evaluating formula: Sourced file: inline evaluation of: `` if (issue.get("customfield_17826").getTime() == null) return null; if (issu . . . ''
Tried using the following but the results are not shown on screen
<!-- @@Formula:
((issue.get("customfield_17937")==null ? null : (issue.get("customfield_17937").getTime()) - (issue.get("customfield_17938")==null ? null : (issue.get("customfield_17938").getTime())) / 1000 / 3600
-->
Please note that both custom fields are Date Time Fields.
You need to test the return value of issue.get(...) against null, not the return value of issue.get(...).getTime() :
<!-- @@Formula: if (issue.get("customfield_17937") == null) return null; if (issue.get("customfield_17938") == null) return null; (issue.get("customfield_17937").getTime() - issue.get("customfield_17938").getTime()) / 1000 / 3600 -->
Thanks David! We are really happy with your add-on and are happier with your support! Thanks again!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.