Is there a way to sort lists manually?

[Rob Bl]

List view fails to accurately sort alphabetically by Status.

Custom filters fail to accurately sort alphabetically by Labels.

It's possible to sort tasks manually in Kanban, but that doesn't carry over into Lists or Filters.

I just want to put MY tasks in MY order of importance in a list. Is that even possible in Jira?

[John Funk]

Hi Rob,

No, the sorting (ORDER BY in Jira terms) is done aphabetically. So you have to manipulate the values in your list somehow if you want them in a certain order. For example, for Priority you can use something like: 1 - Highest, 2 - High, 3 - Medium, 4 - Low

That way it will be in the "right" order and not just alphabetically by priority name. Granted, that is much tricker with things like Status.

[Rob Bl]

What I'm saying is that Jira does not sort alphabetically.

[John Funk]

Please click on the JQL button to the right to show then full query. And then post a screenshot of that. 

[Rob Bl]

There's more query than fits in pop-up, so instead of a screenie, here's the query:

assignee in (currentUser())

and project in (DOC, ROPS, RGT)

and status in ("In Progress", "To Do", "A-List Assignments") ORDER BY status ASC, statusCategory DESC, priority DESC, updated DESC, cf[10011] ASC, resolution ASC

[Rob Bl]

I also tried paring down the end of the query to just ORDER BY status ASC. It didn't help.

[John Funk]

Yeah, that's what I was suspicious of. So you are saying that if you just do:

assignee in (currentUser())

and project in (DOC, ROPS, RGT)

and status in ("In Progress", "To Do", "A-List Assignments") ORDER BY status ASC

That the order does not have all of the statuses together? If so, if you can do a screenshot of that, with the full query and then at least a section of the results where they are out of whack, and then submit that to Atlassian support for their feedback. 

[Rob Bl]

The screenshot would be exactly the same as the one above, just showing the query.

As an end user (not an admin), I'm not allowed to submit anything via https://support.atlassian.com/contact/.

I've created a workaround where I just make separate filters for the two higher-priority statuses, and another one for everything else.

Gads, Atlassian software is exhausting to deal with.

Thanks for trying.

[John Funk]

If no feedback is provided to Atlassian, then they can't fix it. Get your admin to submit a support ticket. 

[Rob Bl]

Admin knows about the problem. But if history suggests a workaround is a better option than waiting for Atlassian to take action, even if the problem is reported by someone Atlassian deems worthy of reporting bugs.

[Hannes Obweger - JXL for Jira]

Hi @Rob Bl

if you sort your issues on a Kanban board, you are modifying the issue's global rank field. You can consider this field in a filter, by using an

ORDER by rank

clause.

Unfortunately, the rank can't be directly modified from Jira's filter views. However, if you're open to solutions from the Atlassian Marketplace, you'll find options there. E.g., this is how this would look in the app that my team and I are working on, JXL for Jira:

For context, JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting. As every JXL sheet is powered by either a saved filter or a JQL statement, you can easily use it as a "supercharged" alternative to the built-in filter views.

Lastly, note that the rank field is always global, i.e., shared for all users. I.e., regardless of the view you are using (e.g., Kanban or JXL): If you rank an issue, it will move for all users, not just for you.

Hope this helps,

Best,

Hannes

[Rob Bl]

Thanks for the suggestion, but plug-in solutions are not up to me. I'm an end-user, not an admin.

The very fact that Jira requires plug-ins to do such basic tasks, while also being so incredibly convoluted and un-intuitive, is one the reasons I started keeping my own To-Do lists separate from the project's shared tools. I guess I'll just have to spend more time doing double the work for what should be simple tasks.

Appreciate the reply.