How to sort the team name in filter

[Ramesh Krishnan]

I am getting below error when i sort Team column in filter: is there way to write jql for sorting or group team name

"Field 'cf[10001]' does not support sorting."

[Hannes Obweger - JXL for Jira · Accepted solution]

Hi @Ramesh Krishnan

from your error message, it indeed looks like the Team field can't currently be sorted in JQL. You may want to watch/upvote on this feature request: https://jira.atlassian.com/browse/JRACLOUD-87808.

In the meantime, if you're open to solutions from the Atlassian Marketplace, you'll have a number of options available. I'll add more information below.

Hope this helps,

Best,

Hannes

[Hannes Obweger - JXL for Jira]

... and to expand on my previous point:

If you're open to solutions from the Atlassian Marketplace, this would be easy to do using the app that my team and I are working on: JXL for Jira.

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 long list of advanced features, including support for (configurable) issue hierarchies, issue grouping by any issue field(s), sum-ups, or conditional formatting.

This all works for all fields, of course including the Team field:

As every JXL sheet is powered by a JQL statement or saved filter, you have full control over which issues you want to work with.

Any questions just let me know!

[Pasam Venkateshwarrao · Accepted solution]

Hi @Ramesh Krishnan 

Welcome to the community,if you add the team field in the screen and the field is not empty then you can try this JQL

project = ABC AND "Team[Team]" = xxxxxxxxxxxxxxxxxx order by Desc

Hope this helps

[Ramesh Krishnan]

it doesnt work for me. its mentioned for one team. i have multiple team under same project. i would like to show like this in filter view

Issue ---------Team------Assignee

1                   A Team         X

2                   A Team         Y

3                   A Team         X

4                   C Team         Y

4                   C Team         Y

[Pasam Venkateshwarrao]

@Ramesh Krishnan you can use the jql for multiple teams

Project =ABC AND Team in ("Team Name 1", "Team Name 2",Team Name3)

After creating the filter, In dashboard use Filter Results gadget

Hope it helps

[Ramesh Krishnan]

Sorry, not works for me. created filter and added gadget, it doesnt shows sorting option against team column :(