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:
Best regards,
Bill
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.