nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get all Tickets in Advanced Roadmaps to show

Heather Ronnebeck

Currently, I am working on a problem where I can only get some of the tickets to show up under the epics in my Advanced Roadmaps. I have a feeling the problem is in my Scriptrunner JQL I'm using.

Basically I have one epic that has over 100 tickets in it, but only 1 of those tickets shows up on my roadmap.

My scriptrunner JQL is:

issueFunction in linkedIssuesOfRecursiveLimited(issuekey="ABC-130", 3) and project != ABC

All of the projects being called in are company managed, and not in the ABC project as expected. I'm wondering how I can get more in.

The structure here is:

ABC Project standard task

(Using issue linking) -> DEF Project Epic

(Using Epic to Story linking) ----> Story/Bug tickets

If anyone has any suggestions I'd greatly appreciate any help I can get here.

Thank you!

Accepted answers

Tom Lister_fo1j4e

Hi @Heather Ronnebeck

If your JQL returns all the tickets you expect, then click the Filter dropdown on the roadmap and check for any further selections.

Tom Lister_fo1j4e

Just a quick follow up and an alternate solution.

I used this query to get all Epics linked to an Initiative in our Roadmaps

issueFunction in linkedIssuesOfRecursive("issuekey=CLOUD-47")

This was then saved as CloudInitiatives.

The I set up a query to get the children of Epics using issuesInEpics . The source JQL for the Epics is the previous saved filter i.e.

 issueFunction in issuesInEpics(" filter = CloudInitiative")

The results can be combined to give epics and children with a simple or

filter = CloudInitiative or issueFunction in issuesInEpics(" filter = CloudInitiative")

I hope that helps.

Tom

All comments

Tom Lister_fo1j4e

Hi @Heather Ronnebeck

If your JQL returns all the tickets you expect, then click the Filter dropdown on the roadmap and check for any further selections.

Heather Ronnebeck

I don't think it is though, @Tom Lister . I think I am missing tickets in my filter because I'm only getting back 270 ish tickets and there are a LOT more than that.

Tom Lister_fo1j4e

Do you have the function

linkedIssuesOfAllRecursiveLimited

available on your system. I think it might have been deprecated but it behaves differently re Epics

Heather Ronnebeck

It's in the cloud and I thought I did have it enabled. It lets me use it. I wonder where I can go to check that.

Tom Lister_fo1j4e

I think function traverses issue links. The Epic/Story relationship is held differently. I thought the ‘All’ function got around that. There is a way to join two sets of filter results but I need to search for that

Tom Lister_fo1j4e

Just a quick follow up and an alternate solution.

I used this query to get all Epics linked to an Initiative in our Roadmaps

issueFunction in linkedIssuesOfRecursive("issuekey=CLOUD-47")

This was then saved as CloudInitiatives.

The I set up a query to get the children of Epics using issuesInEpics . The source JQL for the Epics is the previous saved filter i.e.

 issueFunction in issuesInEpics(" filter = CloudInitiative")

The results can be combined to give epics and children with a simple or

filter = CloudInitiative or issueFunction in issuesInEpics(" filter = CloudInitiative")

I hope that helps.

Tom

Heather Ronnebeck

That also helps a lot. Thank you.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

scriptrunner

jira

cloud

jira-cloud

advanced-roadmaps