Uploaded image for project: 'SR for Jira - Development'
  1. SR for Jira - Development
  2. SRJIRA-3366

Wrong query in "View in Issue Navigator" button

    Details

    • Type: Bug
    • Status: Done (View Workflow)
    • Priority: Medium
    • Resolution: Done
    • Affects Version/s: 5.4.48, 5.4.49, 5.5.0
    • Fix Version/s: 6.5.0
    • Component/s: JQL Functions
    • Labels:
    • Sprint:
      SR4J Sprint 71, SR4J Sprint 72, SR4J Sprint 73, SR4J Sprint 74, SR4J Sprint 75, SR4J Sprint 76, SR4J Sprint 77, SR4J Sprint 78, SR4J Sprint 79, SR4J Sprint 80, SR4J Sprint 81
    • Critical Points:
      0.6

      Description

      The problem

      View in Issue Navigator button displays incorrect results

      Steps to reproduce

      • Navigate to a Backlog (with some incomplete issues)
      • Click the View in Issue Navigator button
      • Is quite possible for the results to differ

      The case

      The JQL for the View in Issue Navigator is

      project = SSPA and sprint is empty ORDER BY Rank ASC
      

      But incomplete issues in a sprint retain their Sprint field values even after the sprint has been ended, and thus are incorrectly excluded by our query. A suggestion is to change the query to

      project = SSPA and (sprint is EMPTY OR sprint not in openSprints() AND sprint not in futureSprints()) and resolution = Unresolved ORDER BY Rank ASC
      

      https://community.atlassian.com/t5/Jira-questions/Why-so-many-issues-in-backlog/qaq-p/1278849

        Attachments

          Structure

            Activity

              People

              Assignee:
              merdmann Marcin Erdmann
              Reporter:
              jmarques Jose Marques
              Votes:
              1 Vote for this issue
              Watchers:
              5 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Structure Helper Panel