Team field not supported for sorting on gadgets, JQL or boards

XMLWordPrintable

    • 1,349
    • 64

      Summary

      Currently, in Jira, you cannot use the Team field as a statistic type or any Dashboard gadgets nor does it support sorting via JQL (ORDER BY Team ASC) or as a filter on boards.

      Proposed solution

      Include the Team field to Jira's supposed field for sorting and statistic type on gadgets for better reporting.

      Workaround

      Use a Custom Field as a Proxy

      • Create a custom single-select field (e.g., "Reporting Team") that mirrors the values of your Advanced Roadmaps Team field.
      • Manually or via Automation, keep this field in sync with the Team field.
      • Use this custom field in JQL, gadgets, and for sorting/statistics. Example: 
      JQL: project = XYZ ORDER BY "Reporting Team" ASC 
      • Gadget: Use "Reporting Team" as the statistic type. 

      Automation Rule to Sync Team to Custom Field 

      • Use Jira Automation to copy the value from the Team field to your custom field whenever the Team field changes.
      • This keeps your reporting field up to date.
      • Example Automation:

        • Trigger: Field value changed (Team)

        • Action: Edit issue → Set "Reporting Team" to match Team value

      • Note: Automation can only copy the Team name, not the Team object, so use a text or select field.

              Assignee:
              Ella Hilton
              Reporter:
              Belto (Inactive)
              Votes:
              633 Vote for this issue
              Watchers:
              295 Start watching this issue

                Created:
                Updated: