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

Permission issues when using JQL Tricks parent() function

XMLWordPrintable

      It is quite difficult to describe what happens here, since we do not completely understand how GreenHopper calculates the permissions. However, all that really matters is that GreenHopper requires the 'Administer Project' permission for a user to allow him to use the 'Add Sprint' button on a rapid board.

      We have created a GreenHopper board and we are now trying to include sub-tasks into the filter via the following query:

      (project = ABC AND reporter = user1) OR issue in parent("project = ABC AND reporter = user1") ORDER BY Rank ASC

      This actually works quite well as long as the parent() function returns something. If it returns an empty set, the 'Add Sprint' button is disabled and GreenHopper complains about a missing 'Administer Project' permission. We changed the query slightly by including two reporters thus forcing the parent() function to return an empty result:

      (project = ABC AND reporter = user1) OR issue in parent("project = ABC AND reporter = user1 AND reporter = user2") ORDER BY Rank ASC

      Now the 'Add Sprint' button is missing even though this JQL query return exactly the same issues as if we remove the parent() function completely ((project = ABC AND reporter = user1) ORDER BY Rank ASC).

      I am not sure if this is problem relates to GreenHopper or JQLT therefore I created a bug report on both ends.

        1. jql-plugin-3.1.1.jar
          973 kB
          Peter Obara
        2. license (1).key
          0.7 kB
          Peter Obara
        3. Screen Shot 2012-09-27 at 9.33.09 PM.png
          32 kB
          Jobin Kuruvilla
        4. Screen Shot 2012-09-27 at 9.33.25 PM.png
          49 kB
          Jobin Kuruvilla

            [JSWSERVER-5918] Permission issues when using JQL Tricks parent() function

            Bugfix Automation Bot made changes -
            Minimum Version New: 6
            Owen made changes -
            Workflow Original: JAC Bug Workflow v2 [ 2851809 ] New: JAC Bug Workflow v3 [ 2934501 ]
            Status Original: Resolved [ 5 ] New: Closed [ 6 ]
            Owen made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v7 - Restricted [ 2545715 ] New: JAC Bug Workflow v2 [ 2851809 ]
            Ignat (Inactive) made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 - Restricted [ 1551635 ] New: JIRA Bug Workflow w Kanban v7 - Restricted [ 2545715 ]
            Confluence Escalation Bot (Inactive) made changes -
            Labels New: affects-server
            Owen made changes -
            Workflow Original: JIRA Bug Workflow w Kanban v6 [ 906584 ] New: JIRA Bug Workflow w Kanban v6 - Restricted [ 1551635 ]
            Oswaldo Hernandez (Inactive) made changes -
            Workflow Original: GreenHopper Kanban Workflow 20141014 [ 743992 ] New: JIRA Bug Workflow w Kanban v6 [ 906584 ]
            mtokar.adm made changes -
            Workflow Original: GreenHopper Kanban Workflow v2 [ 404803 ] New: GreenHopper Kanban Workflow 20141014 [ 743992 ]

            Jobin Kuruvilla added a comment -

            The summary nails it. Thanks.

            Jobin Kuruvilla added a comment - The summary nails it. Thanks.
            Shaun Clowes (Inactive) made changes -
            Resolution New: Not a bug [ 12 ]
            Status Original: Open [ 1 ] New: Resolved [ 5 ]

              Unassigned Unassigned
              4ef8826114c9 Fabian Meier
              Affected customers:
              1 This affects my team
              Watchers:
              5 Start watching this issue

                Created:
                Updated:
                Resolved: