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

Wrong query in "View in Issue Navigator" button

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Done
    • Medium
    • Resolution: Done
    • 5.4.48, 5.4.49, 5.5.0
    • 6.5.0
    • JQL Functions
    • 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
    • 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

        Activity

          People

            merdmann Marcin Erdmann [X] (Inactive)
            jmarques Zeca Marques [X] (Inactive)
            Votes:
            1 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: