How do I order the results by a custom key with the sequence (abc-2509, abc-2616, abc-1403, abc-1402

Jyoti Varade

 

I need to order the issues by a custom key order:

project = "ABC" AND key IN (abc-2509, abc-2616, abc-1403, abc-1402, abc-2581, abc-2596) ORDER BY FIELD(key, abc-2509, abc-2616, abc-1403, abc-1402, abc-2581, abc-2596)"

 

Jim Knepley - ReleaseTEAM

Jira doesn't support custom sort orders, just "asc" and "desc"

This was discussed fairly recently in another thread.