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

Filter Sprint in openSprints() relates to invalid Sprint ID with a normal user

XMLWordPrintable

      Steps to reproduce :

      1. Create a Sprint with issues from multiple project
      2. Create a dashboard gadget(Filter Results) with a filter like : Sprint in openSprints()
      3. Share the dashboard with all users
      4. Check the dashboard by logging in with a admin user and then with a normal user. You are able to see the gadget properly.
      5. Now delete one of the projects from the Sprint
      6. Refresh the gadget
      7. The gadget shows up fine for an admin user
      8. There is an error on the gadget of a normal user : 
        The selected filter filter-12300 has an error: No issues are assigned to a sprint with id 22.
The selected filter filter-12300 has an error: No issues are assigned to a sprint with id 33.
The selected filter filter-12300 has an error: No issues are assigned to a sprint with id 9.

        1. Screen shot 2013-02-13 at 6.13.39 PM.png
          27 kB
          Ruchi Tandon

            [JSWSERVER-7645] Filter Sprint in openSprints() relates to invalid Sprint ID with a normal user

            Malesys Elie added a comment -

            thanks for your quick answer Michael

            Malesys Elie added a comment - thanks for your quick answer Michael

            Michel Daviot added a comment -

            I confirm the workaround, this way of typing JQL is understood :
            project = myProj and Sprint in openSprints()

            Michel Daviot added a comment - I confirm the workaround, this way of typing JQL is understood : project = myProj and Sprint in openSprints()

            Michael Tokar added a comment -

            The regression only presents itself when the sprint JQL functions are typed not in camel case i.e. anything but openSprints() and closedSprints().

            It has been fixed in GHS-8401, which will ship soon. In the mean time, you can adjust your JQL to be the correct case.

            Michael Tokar added a comment - The regression only presents itself when the sprint JQL functions are typed not in camel case i.e. anything but openSprints() and closedSprints() . It has been fixed in GHS-8401 , which will ship soon. In the mean time, you can adjust your JQL to be the correct case.

            David Townsend added a comment -

            +1

            David Townsend added a comment - +1

            Michel Daviot added a comment -

            Same remark as Elie, please reopen the issue !

            Michel Daviot added a comment - Same remark as Elie, please reopen the issue !

            Malesys Elie added a comment - - edited

            This issue still occurs with JIRA Agile 6.3.1:

            for a non admin user the following request : 

            project IN ("My Project") and sprint IN (opensprints())

            leads to :

            Sprint with id 103 does not exist or you do not have permission to view it.
Sprint with id 105 does not exist or you do not have permission to view it.
Sprint with id 115 does not exist or you do not have permission to view it.
Sprint with id 119 does not exist or you do not have permission to view it.
Sprint with id 122 does not exist or you do not have permission to view it.
Sprint with id 132 does not exist or you do not have permission to view it.
Sprint with id 144 does not exist or you do not have permission to view it.
Sprint with id 161 does not exist or you do not have permission to view it.
Sprint with id 168 does not exist or you do not have permission to view it.
Sprint with id 194 does not exist or you do not have permission to view it.

            please reopen this issue.

            Regards

            Malesys Elie added a comment - - edited This issue still occurs with JIRA Agile 6.3.1: for a non admin user the following request : project IN ("My Project") and sprint IN (opensprints()) leads to : Sprint with id 103 does not exist or you do not have permission to view it. Sprint with id 105 does not exist or you do not have permission to view it. Sprint with id 115 does not exist or you do not have permission to view it. Sprint with id 119 does not exist or you do not have permission to view it. Sprint with id 122 does not exist or you do not have permission to view it. Sprint with id 132 does not exist or you do not have permission to view it. Sprint with id 144 does not exist or you do not have permission to view it. Sprint with id 161 does not exist or you do not have permission to view it. Sprint with id 168 does not exist or you do not have permission to view it. Sprint with id 194 does not exist or you do not have permission to view it. please reopen this issue. Regards

            David Townsend added a comment - - edited

            We are running GH 6.2.2 and are still seeing this issue so it should be reopened.

            (Installed plugin Atlassian GreenHopper (com.pyxis.greenhopper.jira version 6.2.2.2)

            A sprint was create in GH but not started and then deleted - looking at the sprint ids in the xml we are now on sprint 33 so I assume the one that was previously not started and deleted must have been 32.

            Any non-admin user that now runs a search including the term opensprints() gets an error.

            search term...
            project = "sandbox" AND status = "resolved" and sprint not in opensprints()

            results...
            normal user:
            Error message "Sprint with id 32 does not exist or you do not have permission to view it"

            admin user:
            the correct results are displayed.

            Our dashboard view is no longer working as we rely on the opensprints() search term.

            Many Thanks

            David Townsend added a comment - - edited We are running GH 6.2.2 and are still seeing this issue so it should be reopened. (Installed plugin Atlassian GreenHopper (com.pyxis.greenhopper.jira version 6.2.2.2) A sprint was create in GH but not started and then deleted - looking at the sprint ids in the xml we are now on sprint 33 so I assume the one that was previously not started and deleted must have been 32. Any non-admin user that now runs a search including the term opensprints() gets an error. search term... project = "sandbox" AND status = "resolved" and sprint not in opensprints() results... normal user: Error message "Sprint with id 32 does not exist or you do not have permission to view it" admin user: the correct results are displayed. Our dashboard view is no longer working as we rely on the opensprints() search term. Many Thanks

            Michael Ruflin (Inactive) added a comment -

            Also retest GHS-7661

            Michael Ruflin (Inactive) added a comment - Also retest GHS-7661

            Nikolay Petrov (Inactive) added a comment -

            on default

            Nikolay Petrov (Inactive) added a comment - on default

            Michael Ruflin (Inactive) added a comment -

            We must not do a per sprint visibility check to fix this issue

            Michael Ruflin (Inactive) added a comment - We must not do a per sprint visibility check to fix this issue

              Unassigned Unassigned
              rtandon@atlassian.com Ruchi Tandon
              Affected customers:
              3 This affects my team
              Watchers:
              11 Start watching this issue

                Created:
                Updated:
                Resolved: