Uploaded image for project: 'Atlassian Product Integrations'
  1. Atlassian Product Integrations
  2. API-482

Not possible to use statusCategory in a JQL filter query in a MS Teams Channel

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Low Low
    • None
    • 1.0
    • Jira Cloud for Teams
    • None
    • Severity 3 - Minor

      Issue Summary

      When using a JQL query which contains values for statusCategory field in a MS Teams Channel, the following error message is shown:

      'in progress' value doesn't exist for 'statuscategory' field

      Example of query:

      project = TEST AND statusCategory in ("To Do", "In Progress")

      Steps to Reproduce

      1. Go to Jira Filters
      2. Create a new Filter using a query similar to project = TEST AND statusCategory in ("To Do", "In Progress")
      3. Set the filter access to Organization
      4. Go to a MS Teams Channel and add a new Jira Cloud Tab
      5. Select the filter created on step 2

      Expected Results

      The filter in MS Team Channel should return all the issues that are returned when using the same filter in Jira.

      Actual Results

      An error message is shown saying that given values don't exist for 'statuscategory' field.

      Workaround

      If the goal is to return all issues which are not in Done status category and if Resolution field is used, the following query might return the same results:

      project = TEST AND resolution = NULL ORDER BY created DESC

            [API-482] Not possible to use statusCategory in a JQL filter query in a MS Teams Channel

            Warrick Hughes added a comment -

            This is caused because the Jira Cloud Teams app sends sends the underlying query of the filter back to Jira api as all lower case text, hence cannot find "in progress" and should be "In Progress".

            This bug has rendered the app unusable for my use case and the same issue also occurs for Organisations filed and breaks the majority of the filters. 

            Warrick Hughes added a comment - This is caused because the Jira Cloud Teams app sends sends the underlying query of the filter back to Jira api as all lower case text, hence cannot find "in progress" and should be "In Progress". This bug has rendered the app unusable for my use case and the same issue also occurs for Organisations filed and breaks the majority of the filters. 

              Unassigned Unassigned
              itrojahn@atlassian.com Ilenice
              Affected customers:
              2 This affects my team
              Watchers:
              5 Start watching this issue

                Created:
                Updated: