Just a heads up: On March 24, 2025, starting at 4:30pm CDT / 19:30 UTC, the site will be undergoing scheduled maintenance for a few hours. During this time, the site might be unavailable for a short while. Thanks for your patience.
×My scenario :
I have list of epics. One of the attributes these epcis have is "version". These epics have children issues. Children issues do not have "version" updated. Only epic has.
So what i wish to do is to write a query that will first get a list of epics that contains a specific version as value, and then list me all the child issues in the results.
Example : show me all the child issues(stories,bugs etc) that are under epics which contains version ID 1.0.2
I would recommend for you using JQL Search Extensions. It's a professional paid indexing service provided by a company I've partnered with.
You can use the following query to get the list of all epic children by a specific version and more reference
issue in childrenOfEpicsInQuery("fixVersion='21.0.1'")
Thanks,
Mohamed Adel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
We put together a plugin called Agile Docs which lets you do this.
You can select your filter for Epics (ie issuetype = Epic AND fixVersion = yourRelease) and Agile Docs will bring up all Epics AND child issues of each Epic.
Here is a screenshot where I've brought up all Epics with the fixVersion Agile Docs Classic Scrum Personal:
Hope that helps!
Best Regards,
Rhys
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
I went on an extensive search for the same thing a little while ago and I found a solution so I thought I would share it with you here.
Firstly, make a filter to pull out the epics which have that attribute, for example:
issuetype = Epic and fixVersion = 0.4.0
Save this filter, and take note of what this filter is called (it will have a number assigned to it which you can see in the URl when you are viewing this saved filter) e.g. filter=24123
Now you want to re-open a new 'search issues' window and put this into the advanced filter query (replacing the filter number with yours as well as the appropriate fix version you are searching for):
issuetype = Epic and fixVersion = 0.4.0 OR issueFunction in linkedIssuesOf("filter = 24123", "is epic of") OR issueFunction in subtasksOf("issueFunction in linkedIssuesOf('filter=24123', 'is epic of')")
What this will do is it will bring up all the epics you want to see, then it will bring up any issues linked to any of those epics directly, additionally it will bring up any subtasks of any issues which are linked to that epic directly.
Let me know how you get on or if it doesn't work and I can try and help you!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @Ilze Schoeman ,
Thank you for coming to my rescue. I tried the query you suggested and I am getting an error :
Does the command issueFunction require some plugin ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi, i'm not 100% sure but can you copy and paste your whole JQL query in here and i can see what it says?
Maybe a screenshot so we can see exactly at which character the issue is occurring and whether or not the query is complete
Thanks
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Januka Wijesingheyes, it seems it comes from Script Runner Cloud.
Could you please confirm you are indeed using Jira Cloud but not have the Script Runner App installed?
https://scriptrunner-docs.connect.adaptavist.com/jiracloud/enhanced-search.html
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
It seems I have ScripRunner Enhanced plugin installed, I see it on my left-hand panel menu on JIRA. So the command "issueFunction" should work in my account ? But its not.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Januka,
Yes I have this:
and we are on the server version of Jira.
Sometimes my 'issueFunction' did not work but it was due to the way i was writing the query. Are you able to copy and paste the whole query including the error message? Then it might be easier to debug
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Januka, I'm sorry I don't know how to fix that :( Apologies, I didn't realise my solution was using one of the add-ons we had already. Sorry I could not help more.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
@Januka Wijesinghe
according to documentation you would have to switch to the enhanced search - I cannot determine from your screenshot if you did do that.
Please have a look at this video:
https://scriptrunner-docs.connect.adaptavist.com/jiracloud/enhanced-search.html
If this should not succeed I'd encourage you to raise a request with Adaptavist.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Small update on ScriptRunner based solution you suggested.
We have included the plugin, just now saw why it did not work , issueFunction does not support next-gen projects.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Ah, I see. That is bad news indeed, at least the error message is clear on the cause.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
If you would be interested in a ready made solution, You may want to try out our plugin,
Agile Tools : Epic Tree & Time in Status
You can get all the issues under the Epic for a release version, with its complete hierarchy and their progress.
Key features of Epic Hierarchy:
Along with Epic Sum, you also get 2 other important functionalities within the same plugin, Links Hierarchy and Multiple Time in Status reports (to track your issues).
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Looks good! I will first try to see whether I can do this without external plugins and then try your plugin.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.