Calculated custom field how to

[arama mihai]

Hello,

I'm trying to make a calculated custom field, either text or number, using the "Misc custom fields" from Inovalog add-on.

The formula I'm using is:

for calculated number:

<!-- @@Formula: String issueType = issue.get("issuetype").getName().toString(); if (issueType.equals("ProgramEpic")) { return 1; } else if (issueType.equals("Epic")){ return 2; }  else if (issueType.equals("Story")){ return 3; }  else if (issueType.equals("EnablerStory")){ return 4; }  else if (issueType.equals("Defect")){ return 5; }  else if (issueType.equals("Sub-task")){ return 6; }

The field has the value, but when I do the query: Project = ABC order by Hierarchy ASC, it does not arrange them in order;

for calculated text:

<!-- @@Formula: String issueType = issue.get("issuetype").getName().toString(); if (issueType.equals("ProgramEpic")) { return "A"; } else if (issueType.equals("Epic")){ return "B"; }  else if (issueType.equals("Story")){ return "C"; }  else if (issueType.equals("EnablerStory")){ return "D"; }  else if (issueType.equals("Defect")){ return "E"; }  else if (issueType.equals("Sub-task")){ return "F"; }

This does not even add a value into the field.

Please let me know what the correct formula would be, or , for the number field, if it is correct, why does the order by does not work.

Thank you.

[arama mihai · Accepted solution]

A reindex was needed.