Number calculated field not properly sorted
Hi, I am using a little bit more complex math expression in number calculated field and jira is not sorting by it's value. Value is being calculated properly.
Comments (8)
-
repo owner -
reporter Hi @fcarmario Ok, getMatchingValue is a great function to use for this case. I optimised my expression as you proposed but it is still timing out.
I took out all other logic except this one, still not being sorted.
getMatchingValue(floor(({00057}-{00009})/{DAY}), [00, 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29, 30, 31, 32, 33, 34], [00, 05, 08, 10, 11, 12, 12, 12, 13, 13, 13, 14, 14, 14, 15, 15, 15, 16, 16, 16, 17, 17, 17, 18, 18, 18, 19, 19, 19, 20, 20, 20, 21, 21, 21, 22])
-
repo owner Hi @mugrin5117,
Try reindexing your JIRA instance, please.
-
reporter Ok, will do it and will let you know after reindexing
-
repo owner Hi @mugrin5117,
Any update on this issue?
-
reporter Hi @fcarmario, sorry for not answering earlier, was waiting to our sys admin to create test jira instance. We performed reindex, but still the same, sorting is not working. We have a quite large jira instance, more then 1300000 tickets, maybe this is making performance problems?
-
repo owner Hi @mugrin5117,
I'm closing this issue. Please, reopen it if you think I can help you on this. Thanks.
-
repo owner - changed status to resolved
- Log in to comment
Hi @mugrin5117,
The problem is that you expression takes too long to be calculated, and JIRA withdraws from trying to sort by the field.
You can do the following 3 optimizations in your formula:
Replace term:
with term
Replace term:
with term
Replace term:
with term
Try not to use more parentheses than the necessaries, since they also take some time to be evaluated.