case when - JIRA custom "order by" on text field -
my jira query goes following:
(status = "in progress" or status="test failed") , assignee = currentuser() order priority desc, due asc, status desc, key asc
the problem is, priority text, , medium
comes first before low
, high
. if order task ascending, medium
issues go end of list. tried case-when-then expression, jql won't let me reserved words. how can define custom ordering?
if priority text field, sorting alphanumerical order (ascii think). people work around changing names 0-high, 1-medium, 2-low, or "p1 high", "p2 medium" , "p3 low". or can define custom field priority select field options named low, medium, high , change order during field configuration.
Comments
Post a Comment