You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
I’m Maurício, a support engineer at Appfire and I’m here to help you.
Unfortunately, using JQL of Jira, you’ll not be able to do it dynamically.
In the app where my team works, JQL Search Extensions for Jira, you can use this query to find all the Epics which the ‘Parent link' is an initiative of the project MT-Feel.
issue in childrenOfIssuesInQuery("project='MJP' and type=Initiative") and type=epic
Please contact our support if you have any other questions about this query.
We’ll be happy to help you!
Hi @mauricio.groth !, Thanks in advance for your support.
Let me share with you that I found a solution , using the function,
LinkedIssuesofrecursive(subquery, [link name..])
In my case, issueFunction in linkedIssuesOfRecursive("project = MTFEEL", "is parent of")
Thanks & best regards,
unfortunately, this is trickier than one might think; as a "hierarchical query", it would really require some kind of "join" or "subquery", which isn't available in plain Jira/JQL.
A few directions forward:
If you want to run your search "dynamically", without manually "stitching" two queries together, you'll need extra tooling:
Hope this helps,
Just to expand on the last point, this is how this would look in the app that my team and I are working on, JXL for Jira. Put simply, you create a sheet with all your relevant initiatives and any potential epics below these initiatives. You then configure your hierarchy (that's just a couple of clicks) and hide all issues that exist "outside" of this hierarchy:
Once you have your set of issues, you can work on these issues directly in JXL (much like you'd do in e.g. Excel or Google Sheets), trigger various operations in Jira, or export them for further processing.
Any questions just let me know!
Firstly, thanks for sharing all of those alternatives. Great help for me!
What a pity!, I'd need showing up all the Epics which 'Parent link' is a initiatives of the project M-Feel.
I mean, you guy know, showing in a Plans all the initiatives of MT-Feel project and in cascade with their epics (whatever project belong)
I thought that exists some Jira functions for that,( e.g linkedIssues(), epicsOf(),...) which could answer if its project parent link is MT-Feel or something like that... :(
@Nieves García yeah understood - I believe you should be able to do this with a Marketplace app.
Another thing I could think of is to create a Advanced Roadmaps plan with two filters: One filter that pulls in all your initiatives from MT-Feel, and another filter that pulls in any potential epics (from any projects you generally care about). Advanced Roadmaps should then show the epics under their initiatives, and all other epics in a special "Issue without parents" bucket that you can just ignore.
This is similar to how it would be done in JXL, except that JXL has an option to completely hide any "issues without parents".
Hi @Hannes Obweger - JXL for Jira , thanks a lot for your ideas and comments. It was great help for me. Finally, I found a solution , this is using the Function,
LinkedIssuesofrecursive(subquery, [link name..]),
this function traverses issue links recursively to return all issues that are linked (directly and indirectly) to the results of the initial subquery.
In my case : issueFunction in linkedIssuesOfRecursive("project = MTFEEL", "is parent of")
Thks & Best Regards,
To find all Epics from different Jira projects with a specific value for the "Parent link" field, linked to Initiatives of a specific project, you can use the following JQL query:
project in (<project1>, <project2>, ...) AND issuetype = Epic AND "Parent link" in (project = <initiatives_project>) AND "Parent link".issuetype = Initiative
Make sure to replace <project1>, <project2>, ... with the project keys of the Jira projects where you want to search for Epics, and <initiatives_project> with the project key of the project where Initiatives are stored.
This query will search for all Epics in the specified projects that are linked to Initiatives in the <initiatives_project> project via the "Parent link" field.
You can save this query as a filter in Jira and use it as a basis for your Plans filter. Note that the Initiatives project should also be added to your Plan in order to use this filter.
Hi Javad, thanks a lot for your answer. But let me explain in more details what I need,
I have a 'jira project', MT-Feel, with Initiatives and epics included under them. But, those epics can belong others jira projects that for starting I don't which are...
I mean, I'd need to show all Initiatives of jira project (MT-Feel) with its Epics included whatever project belongs (not only from MT-Feel).
Thanks in advance!,