Uploaded image for project: 'Jira Software Data Center'
  1. Jira Software Data Center
  2. JSWSERVER-16172

Get projects API doesn't return projects if JQL returns all but a few excluded projects

      Summary

      On creating a board with a JQL filter which results in issues from all but a few excluded project, the following REST API,

      GET /rest/agile/1.0/board/{boardId}/project
      

      does not return any projects for that board.

      Examples of affected JQL queries,

      • project != ABC
      • project NOT IN (ABC,XYZ)

      Steps to Reproduce

      1. Create a board in Jira
      2. Modify the filter query of the board to include the conditions shown in the above examples.
      3. Get results from the REST API command above

      Expected Results

      The query returns projects that are listed based on the JQL query

      Actual Results

      No projects are shown

            [JSWSERVER-16172] Get projects API doesn't return projects if JQL returns all but a few excluded projects

            SET Analytics Bot made changes -
            UIS Original: 2 New: 0
            SET Analytics Bot made changes -
            UIS Original: 0 New: 2
            SET Analytics Bot made changes -
            UIS Original: 1 New: 0
            SET Analytics Bot made changes -
            UIS Original: 0 New: 1
            Bugfix Automation Bot made changes -
            Minimum Version New: 7.04
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2853224 ] New: JAC Bug Workflow v3 [ 2937274 ]
            Michael Andreacchio made changes -
            Status Original: Needs Triage [ 10030 ] New: Gathering Impact [ 12072 ]
            Owen made changes -
            Symptom Severity Original: Minor [ 14432 ] New: Severity 3 - Minor [ 15832 ]
            Owen made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v7 - Restricted [ 2543666 ] New: JAC Bug Workflow v2 [ 2853224 ]
            Status Original: Open [ 1 ] New: Needs Triage [ 10030 ]

            Dave Elkan added a comment -

            This bug/lack of functionality has caused a number of new support requests for our users with complex board queries. We're constantly trying to ensure our apps work around this, but it's becoming increasingly difficult. 

            Dave Elkan added a comment - This bug/lack of functionality has caused a number of new support requests for our users with complex board queries. We're constantly trying to ensure our apps work around this, but it's becoming increasingly difficult. 

              Unassigned Unassigned
              jthomas2@atlassian.com Joshua Thomas (Inactive)
              Affected customers:
              20 This affects my team
              Watchers:
              16 Start watching this issue

                Created:
                Updated: