How to get a list of "issues in epic" in Jira

[vaishali saraf]

We link issues to Epic in Jira.

2 ways to add a bug in epic

1) From a bug  – click 'More' => click link and select "Related to" and type in the epic number.

Now the issues will be related to the epic.

To get a list of linked issues

issue in linkedIssues("ABC-123") – works.


2)  From bug screen  click "Edit" and add epic link.

When we do that the bug is seen "issues in this epic" section.

How to get a list of the the "Issues in this epic" with their key and current status.?

thanks

[Nikhil_Gupta]

Just Use the search keyword Epic Link and give the id of Epic, like this:

1. "Epic Link" = ABC-123 , or
2. "Epic Link" in (ABC-123, PQR-456, JQL-946)

No need to add quotes ("") in the Epic ids.

Regards,

[Humberto Nunez]

Thank you Nikhil.  Worked perfectly! :)

[Nikhil_Gupta]

@Mario Binder See if this solution helps

[Mario Binder]

@Nikhil_Gupta Thanks. For my case works this:

issue = ITE-48 OR parentEpic = ITE-48 ORDER BY createdDate ASC

[Karthik Varma A]

@Nikhil_Gupta : This is Simple and Easy solution when i was actually trying to invent very complex query for it

[Michael Schlueter _secunet_]

How about ("Epic Link" = ABC-123)? Should be as easy as that. Maybe I've got you wrong.

[Deleted user]

And if you have multiples;

"Epic Link" in (ABC-123,EFG-123, ABC-456,etc...)

or

If you don't want to list all the EPICs then: "Epic Link" is not EMPTY

Then export the info to excel and rock-on!

[Matthew Gately]

You are absolutely right, however, I actually found benefit from the given answer using linkedIssuesOf(), because my list of Epics is itself derived using a filter, and so can't be hardcoded like is done here.

[Mel Dett]

I have a query to derive the Epics in which I want the linked issues.  Is there a way to list the linked issues within the query that derives my Epics?  I'd like to do this with just one query.  seems I should be able to.  I do not yet have script runner.  I tried linkedIssuesOf() but keep getting operator errors.  Like you the query derives the Epics.

[ahmed94]

Hi I just tried with Epic Link and I get Le champ 'Epic Link' n'existe pas. 

[Jose Vicente Martinez]

I use this query

issuefunction in linkedIssuesOf("key = PROD-1816", "is Epic of")

[RPandyaram]

hi @vaishali saraf ,

Epic link is majorly used to link a story .

Query can be like this for a story:

issuefunction in linkedIssuesOf("project = ABC", "is Epic of")

Bugs can be linked to an epic with 'Relate' as well.

For 'Relate'  issue link , the outward and inward description is same 'Relates to' by default.

If you want them to be separately defined , edit the description under issues tab with admin rights.

Once you have new links towards the epics from bug, use the same query 'issuelinks'.

Hope this helps.

[vaishali saraf]

Thanks for your answer .

issuefunction in linkedIssuesOf("project =RDPROG" , "is Epic of")

When I tried above query... I got 

"Field 'issuefunction' does not exist or you do not have permission to view it."

Sorry... I am struggling here a bit.  

One this is not clear ...Where should I give the number of epic ( Issue key) whose issues I want to display.

[Michael Schlueter _secunet_]

For the issuefunction you need the Script Runner Plugin.

[Joel]

everytime i try to do anything advanced in JQL i come back to... "go get the script Runner Plugin". This is not cool.

[William Stephens]

Completely agree, this is extremely annoying

[Joel]

So its been a few months since my company broke down and bought script runner. I will say this. It's a fantastic plugin and does a million and one things. The big stinky though is that we have to shell out a small fortune for this added functionality that really would be awesome if it was part and parcel to the Atlassian tool set.  After getting my head around groovy and the API it's fairly stunning as to what can be accomplished. If you haven't bought it and have a few plugin's on a list of items to buy but are confused as to which ones should be priority... Script Runner should be at the top of your list.

[Joel]

Also I'll add I don't work for script runner or am no way associated with that company.

[jennifer]

I get that scriptrunner is great and all, but if Jira is supposed to be about supporting Agile processes (which are supposed to be focused on user needs), that functionality should be built in. It's a little ironic that users everywhere on these forums ask for the capability to query hierarchies of issues from epics through stories and tasks, and the answer for years continues to be 'go buy a separate plugin'.

I've only been using Jira for 3 months, and I have already identified 6 key features of project tracking, this one included, that I don't have access to without a paid plugin (if it's available at all). I don't have the luxury of funding all those plugins, let alone waiting for the internal review and approval processes to go through for each one so that I can start tracking my work. A true user-centered product design would incorporate that kind of constraint into the product structuring and pricing so that customers aren't left high and dry without important capabilities during implementation. 

Seriously - this violates everything that Jira is supposed to be about supporting. 

[Nancy Stronczek]

We don't have Scriptrunner or any other add-in to help with JQL.  I'm using Jira Cloud (no version # specified in the About dialog), and this is what worked for me today in the Advanced Search JQL builder bar:

project = XYZ AND issue in linkedIssues("XZY-123") ORDER BY priority DESC, updated DESC

[brbojorque]

issuefunction in linkedIssuesOf("key = ABC-123", "is Epic of")

An alternative answer.

[Priya Martin]

Is it possible to use a query in place of hardcoding a specific epic issue key?

[brbojorque]

Yes, essentially the first parameter can be any JQL expression, however be careful of putting complex JQL because it may affect the performance.

It is worth noting that this is a ScriptRunner function.

https://scriptrunner.adaptavist.com/5.5.8/jira/jql-functions.html

[Neeru Karwal]

Thank you @brbojorque 

[Marco António Pereira dos Santos]

I am trying to create a query and doesn't work. This query is compose for 2 criteria, one criteria is in Epic and another criteria is in task. Is it possible ? When use only criteria (epic or task), it's OK, it works very well, but I combine both criteria doesn't work, why ? Is there any function or someone help me ? Thanks in advanced.

[Dave Hearne]

issue in childIssuesOf (epic key)

The above worked perfectly for me. Replace epic key with your own info. The name of the Epic will not work, even in quotes.

[Brian Oconnell]

"Unable to find JQL function 'childIssuesOf(abc-123)'."

[Junio Fernandes]

This may help:

issue in issuesParents("project = ABC or project = ABD")

It lists all items related to each epic under the projects.

[Mario Binder]

Unable to find JQL function issuesParents

[Michael Schlueter _secunet_]

I think this JQL function is provided by the AM utils app available on the Jira marketplace.

[Nic Brough -Adaptavist-]

It's not, it's a Scriptrunner function.