Uploaded image for project: 'Jira Cloud'
  1. Jira Cloud
  2. JSWCLOUD-17392 Team-managed software projects
  3. JSWCLOUD-17239

As a user, I'd like to be able to use JQL for Epic Link for Next-Gen project epics

    • Icon: Sub-task Sub-task
    • Resolution: Done
    • None
    • None
    • next-gen

      Atlassian Status as of 12 December 2019

      Hi everyone,

      Customers can query on Next-gen epics using the parent =. If you want to combine Epics from both project types, an example of such a query would be:
 "Epic Link" = NPC-6 OR parent = NJDP-5

      The Parent field can now be selected as a column in the Global Issue Navigator and exported from Jira.


      Regards,


      Nathan Sturgess
      nsturgess@atlassian.com

      Product Manager, JIRA Platform

      Original request description

      WIth the deploy of the epics and linking the issues to the epics at the Next-Gen projects we can't use the JQL to return issues that are associated to an epic as we can do for classic projects.

      Steps to reproduce

      1. Create a next-gen project
      2. Create an epic
      3. Associate multiple issues to the epic
      4. Go to Issue Navigator and try to perform the search by Epic Link referencing the Next-Gen epic
      5. No results are displayed

      Expected results

      Return the list of issues that are linked to the referenced Epic

      Actual results

      Use parent() function to show the child issues of the Epic. Example:

      parent = EPIC-123
      

            [JSWCLOUD-17239] As a user, I'd like to be able to use JQL for Epic Link for Next-Gen project epics

            Please reopen and add support for timesheet functions.

            Michael (Admin) added a comment - Please reopen and add support for timesheet functions.

            Can you please reopen, as we need Tempo reports to list Project > Epic > Issue > Sub-Task, see problem description here https://community.atlassian.com/t5/Jira-Software-questions/Tempo-report-doesn-t-show-Epics/qaq-p/1597821

            Anne-Marie Scheidegger added a comment - Can you please reopen, as we need Tempo reports to list Project > Epic > Issue > Sub-Task, see problem description here https://community.atlassian.com/t5/Jira-Software-questions/Tempo-report-doesn-t-show-Epics/qaq-p/1597821

            Following for need Epic/Parent Name in the query results for macro in confluence.  it just shows key which is not helpful. like  in JQL results it shows parent name. 

             

            Shruti Anand added a comment - Following for need Epic/Parent Name in the query results for macro in confluence.  it just shows key which is not helpful. like  in JQL results it shows parent name.   

            I am able to pull the Epic/Parent name in the query but it only exports the Key.  Is there not a way to export the name also?  I could do this before moving to NextGen.  

            Linda Boone added a comment - I am able to pull the Epic/Parent name in the query but it only exports the Key.  Is there not a way to export the name also?  I could do this before moving to NextGen.  

            Hi guys!

            It looks like there is no real workaround apart from getting the child issues of the epic and then searching for subtasks of stories in the epic. And this solution only works for some one-off use cases.

            If you need full support for Epic->Story->Subtask hierarchies, consider our professional paid indexing service JQL Search Extensions for Jira Cloud.

            After you install the app you can get all issues under your epics:

            issue in childrenOfIssuesInQueryRecursive("key in (EPIC-1, EPIC-2)")

            I hope it's of help to at least some of you!

            Daniel Turczanski - 🔎JQL Search Extensions added a comment - Hi guys! It looks like there is no real workaround apart from getting the child issues of the epic and then searching for subtasks of stories in the epic. And this solution only works for some one-off use cases. If you need full support for Epic->Story->Subtask hierarchies, consider our professional paid indexing service JQL Search Extensions for Jira Cloud . After you install the app you can get all issues under your epics: issue in childrenOfIssuesInQueryRecursive("key in (EPIC-1, EPIC-2)") I hope it's of help to at least some of you!

            I have exactly the same problem with sub-tasks and it is driving me slightly mad.

            We have now had to ask the team to never log time under sub-tasks, otherwise it is time that just disappears.

            Quite frankly the issues with the changes to Epics and parents for next gen projects is baffling.

            Michael Trice added a comment - I have exactly the same problem with sub-tasks and it is driving me slightly mad. We have now had to ask the team to never log time under sub-tasks, otherwise it is time that just disappears. Quite frankly the issues with the changes to Epics and parents for next gen projects is baffling.

            Hi @Nathan Sturgess,

            Above solution works and it pulls only the Story, Task and Bugs under the epic but not the subtasks under the story.

            Actually I am trying to use the JQL in Tempo for Logged Time Report. In Classic Software project Filter by Epic works like a charm but since we moved to Next Gen project Filter by Epic is not working. As alternate solution I am trying to use JQL whereas the query appears as below. Problem here is, report pulls all the time logged under Story, Task and Bug issue types but the time logged under "subtasks" are not getting accounted.

            JQL: project = ER AND parent in (ER-2)
            ER-2 is the Epic
              ER-3 - Story 1
                ER-4 - Sub Task 1
                ER-5 - Sub Task 2

             ER-6 - Story 2
               ER-7 - Sub Task 1
               ER-8 - Sub Task 2

            What I am looking for?: My JQL should pull all the Story under Epic "ER-2" along with subtasks so that I can use the JQL in Tempo

            RamPrasanth.Jahadhishan added a comment - Hi @Nathan Sturgess, Above solution works and it pulls only the Story, Task and Bugs under the epic but not the subtasks under the story. Actually I am trying to use the JQL in Tempo for Logged Time Report. In Classic Software project Filter by Epic works like a charm but since we moved to Next Gen project Filter by Epic is not working . As alternate solution I am trying to use JQL whereas the query appears as below. Problem here is, report pulls all the time logged under Story, Task and Bug issue types but the time logged under "subtasks" are not getting accounted. JQL:  project = ER AND parent in (ER-2) ER-2 is the Epic   ER-3 - Story 1     ER-4 - Sub Task 1     ER-5 - Sub Task 2  ER-6 - Story 2    ER-7 - Sub Task 1    ER-8 - Sub Task 2 What I am looking for?:  My JQL should pull all the Story under Epic "ER-2" along with subtasks so that I can use the JQL in Tempo

            Took me forever to find this answer. Thankfully, it worked. 

            ShantaDotCa added a comment - Took me forever to find this answer. Thankfully, it worked. 

            That's worked.  Thanks @Nathan Sturgess

             

            Karen Fynn added a comment - That's worked.  Thanks @Nathan Sturgess  

            Hi karen5,

            Sorry for the inconvenience this has caused you, the bug has been triaged to be fixed.

            In the meantime there is a workout here: https://jira.atlassian.com/browse/JRACLOUD-74373

            Regards,
            Nate

            Nathan Sturgess (Inactive) added a comment - - edited Hi karen5 , Sorry for the inconvenience this has caused you, the bug has been triaged to be fixed. In the meantime there is a workout here: https://jira.atlassian.com/browse/JRACLOUD-74373 Regards, Nate

              nsturgess Nathan Sturgess (Inactive)
              dbraun@atlassian.com Douglas B (Inactive)
              Votes:
              602 Vote for this issue
              Watchers:
              306 Start watching this issue

                Created:
                Updated:
                Resolved: