We have an issue type called Lowlevel requirements and we link issue type stories to it. How can I create a query that lists all the lowlevel requirements in a project along with their linked story details.
LLR1 - Summary >>
STY 1- Summary 1
STY 2- Summary 2
LLR2 - Summary
Basically a report to show the linked issues as well any parent that is missing the links of type Story.
You could use the linkedissues() function in JQL in order to search for all the issues linked to this LLR1 issue. So for example, if your LLR-1 was the issue key, you could create a JQL search such as
issue in linkedissues(LLR-1)
This would return all the issues in JIRA that are linked to that LLR-1 issue. From there you could then just adjust which columns you wanted to see in the search results to include the Summary field. That way you could do this natively within JIRA. Just note that this alone would not return the LLR-1 issue, just the issues linked to it. But if that too is important to the search results, it could easily be adjusted with something like
issue in linkedissues(LLR-1) OR issuekey=LLR-1
Thanks Andy. I tried that already. But I'm loking for not a specific issues id. I am looking for all the LLR's for a given project and their linked stories in one query, incluidng summary and id for both LLR's as well as Stories. I couldn't achieve through the JQL.
Ah, in that case, then yes, the native JIRA JQL searching probably won't be able to do all this. However I would recommend taking a look at a plugin to JIRA that should be able to do this. For example the JQL Tricks plugin has a function called linkedIssuesInProject that appears it could be used to find all the linked issues on a per project basis.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot