How to obtain issues from a group and its subgroups

Create issue
Issue #26 closed
Marta Lopez Reyes created an issue

Hi,

I am trying your app and it seems that is the solution to my need but I don't know how to make a query
to find all projects in "programa" and its children

I have this hierarchy:

  • Programa 0

    • Aplicacions 4
    • Projectes 5

      • Iniciativa 10

This query doesn't work for me: (zero results)

---- project in projectGroups("Programa") -----

Could you please help me to find the way to obtain all the issues from "Programa" ??? I hope it is possible!

Thanks

Comments (13)

  1. [NPES] Alexey Dorofeyev repo owner

    Hi Marta,

    The only way to do it right now is to list all subgroups of the group you need in the arguments of the jql function.

    In your example it will be:

    project in projectGroups("Programa", "Aplicacions 4", "Projectes 5", "Iniciativa 10")
    

  2. Marta Lopez Reyes reporter

    Thank you for your fast response!

    If this is the solution (as I Intuited), It won’t be a good solution for us 😞 . I think the powerfull of having hierarchy is to be able to search by “the mum” group.

    Are you thinking about implement this implovement at the search?

    Thanks and goog luck

  3. [NPES] Alexey Dorofeyev repo owner

    We have jql function projectGroupsHierarchy() which is what you need. It’s not documented, as it’s not fully tested yet, but i think it works pretty well. You can try it like this:

    project in projectGroupsHierarchy("Programa")
    

  4. Marta Lopez Reyes reporter

    sorry, sorry, it works. Thanks! I have another question: is this field compatible with eazybi?

  5. [NPES] Alexey Dorofeyev repo owner

    This is not a field, projectGroupsHierarchy() and projectGroups() are functions, that returns array of projects

  6. Cathrine Chanslor

    @Marta Lopez Reyes How did you get the projectGroupsHierarchy() to work? We are having issues with this function. What version of Project Groups for Jira are/were you running? Thanks!

  7. Cathrine Chanslor

    Actually it is working great now.

    When my user was testing it, he reported that he had no issues returned. When I was reviewing his example, I noticed an error in spelling for one of the groups. I tested it with the correct spelling and got back issues, as expected. The other example he tried (spelled correctly), he said no issues returned but when I tried it, I got the issues. So… honestly, I do not have any idea why that one failed for him the first time.

    I would say there are no problems with this as it stands now.

  8. Log in to comment