I've got a bunch of tickets with the following summaries
I'd like to be able to do something like this: `ORDER BY substring(summary, 1,3), key` so I get an ordered list like this
Never mind the naive substring selection (I know it'll break if those numbers go into double digits), but can I do an ORDER BY like this?
I've got a horrible feeling (since I've not been able to find any examples), I'll need to create a custom field and store the rank there and sort that.
In your example, the thing you wanted to sort-by was always at the beginning of the summary. So why not just ORDER BY summary?
If instead your substring is after the beginning, you would:
Hello Community! We thoroughly enjoyed this just-for-fun conversation in the Jira Admin Group about what it's like to be a Jira Admin. For #JiraJuly, our talented designers created these graphics t...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events