Query for Lead Developer on Linked Issues

Question

Like the title says, I'm trying to query to pull data for issues where their linked issues have a specific Lead Developer on them.

Sadly, I don't even really know where to start with this one.

I do have access to Script Runner.

Any help would be much appreciated!

Kalyan Sattaluri_iinm1n · Answer

Hello @Sofie Palacios

Since you have script runner:

Below query will give you all issues which are blocking project ABCD and are open

issueFunction in linkedIssuesOf("project = ABCD", "blocks") AND resolution IS EMPTY

Then to find issues assigned to one user, you add additional clause:

issueFunction in linkedIssuesOf("project = ABCD", "blocks") AND resolution IS EMPTY AND assignee = "u787823"

If you dont care about link type, just dont give that argument like below:

issueFunction in linkedIssuesOf("project = KPMS") AND resolution IS EMPTY

And it will bring all linked issues which are open and you add the assignee clause again to find the list you are interested in:

issueFunction in linkedIssuesOf("project = ABCD") AND resolution IS EMPTY AND assignee = "u787823"

Hope it helps.

Dave Rosenlund (Trundl) · Answer

Hi, @Sofie Palacios  👋

You'll want to do an Advanced Search using JQL. In this case, you'll need to learn how to use the "linkedissues()" and "assignee=" and maybe other conditions.

Checkout:

Advanced searching

to learn more.

Hope this helps,

-dave