JIRA Query for Depends on issue link that are closed

[KE]

I need to pull the list of stories that have associated issue type = "depends on" and the status = "closed".

[David Niro]

Hello @KE ,

David from ALM Works here. 

If I understand correctly, you want to show Open issues from a certain project and then show the Closed issues linked to them.

Since you are using Structure, you can accomplish this goal by using an Insert Generator, an Extend Generator and a Filter Generator.

You will start by adding the Open issues from your project with the Insert Generator.

Next, you will add Extend Generators to add the issues that are linked to those issues by (blocks, depends on, etc). One for each.

Lastly, you will add a Filter Generator (JQL) for status = Closed and set the level to 2.  This will remove all the open blocks, depends on, etc issues.

Please let me know if this helps!

Best,
David

[KE]

Hi David,

Our admins tried to execute the steps you provided, but were unable to get the outcome I'm looking for.

A ticket is submitted to ensure it is processed through - ALM-29983-Vendor ticket

[Mark Segall]

Hi @KE and welcome to the community!  Give this a try:

status = Closed AND issueLinkType = "depends on"

[KE]

Thank you, Mark!

• The non-dev tickets that I'm working on have "relates to" and "depends on" issue links.
  However some of the "depends on" tickets are closed and some are not.
• I did try with the combination below - however when I search I still see the "depends on" linked tickets that are closed being populated. 

project = "XYZ" AND
issuetype = "Non Development" AND Status in ("closed,In Progress")
AND labels in (XYZ)
AND status != Closed AND issueLinkType = "depends on"

[Mark Segall]

Hi @KE - I apologize, but I'm not sure I'm understanding what you're trying to achieve. Specifically, what I'm finding confusing are the two status arguments:

• status in ("Closed,In Progress") 
• status != Closed

Let's take a step back... Is the problem you're trying to solve where you're trying to query issues on project XYZ where their status is "Closed" or "In Progress" and their dependency issues are open?  If so, this is not something you can query natively and would likely require something like ScriptRunner.

[KE]

Sorry for the confusion.

Yes, I was looking to query issues on a project XYS where their status is "Open" or "In Progress" and their dependency issues are "Open".

Is there any helpful information around Script Runner that I can learn from Atlassian Community? 

[KE]

@Mark Segall My team has provided me access to JIRA Structure. 

How can I use JIRA Structure to get results

For open/in-progress tickets under a certain project -

Which have issue links to associated tickets such as (blocks, dependent on, depends on)

And those issue links are either closed, de-scoped or are in UAT? 

What is the JQL query for this and can I use Structure to get the results or should I get SCRIPT Runner?

[Mark Segall]

Hi @KE - Unfortunately, I can't help with Structure or Script Runner.  Though I believe script runner can handle what you're looking for.  Hopefully someone else in the community can chime in on this one.

[KE]

Thank you