Error encountered for the a similar formula below
2014-08-19 08:21:31,083 http-bio-8080-exec-14 ERROR USER1234 501x95052x2 1b6xxqy 202.167.233.229,10.241.12.70 /browse/HRT-2273 [innovalog.jmcf.fields.CalculatedTextField] CalculatedTextField: error evaluating formula: Sourced file: inline evaluation of: `` Object CG1 = issue.get("customfield_10800").iterator().next().getName().sub . . . '' : Typed variable declaration
<!-- @@Formula:
Object CG1 = issue.get("customfield_A").iterator().next().getName().substring(7,13);
Object CG2 = issue.get("customfield_B");
if ((issue.get("customfield_A")==null || issue.get("customfield_A").size() == 0) && (issue.get("customfield_B")==null)) return null;
if ("ABCDEF".equals(CG1)||"GHIJKL".equals(CG2)) return "YES";
if ("GHIJKL".equals(CG1)||"GHIJKL".equals(CG2)) return "NO";
return "Unavailable";
-->
I'm getting results except when customfield_A is blank. It gives back nothing.
customfield_A is a multi-group field.
customfield_B is a pick-list field
I found the solution. I recoded it a bit and made sure the NULL CHECKS come first.
I have the same problem, what do you mean with "made sure the NULL CHECKS come first."? Thank you
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You need to check if the custom field you have is BLANK or NULL before proceeding to the other conditions. Sorry for replying late.
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.