How to get all tickets that are delegated, but delegating ticket is closed with JQL

paul.finnedison December 16, 2019

Hi,

I'm trying to query for all ticket that are:

  • delegated form another ticket (no matter form where)
  • where the delegating ticket is already closed
  • not closed them self

Currently I have something like this:

project = "Product" AND status != closed AND issue in hasLinks("is delegated from") AND issue in hasLinks("status = closed").

this seems to work somehow - but not returning all of them.
I'vent determind so far what the limitation is for that query.

Does anybody have an Idea what could the issue?

 

 

1 answer

0 votes
Jack Nolddor _Sweet Bananas_
Marketplace Partner
Marketplace Partners provide apps and integrations available on the Atlassian Marketplace that extend the power of Atlassian products.
December 17, 2019

Hi paul.finnedison,

Sadly you cannot use native JQL functions for such a complex query, you need to go for a third-party instead. Using i.e. JQL Booster Pack you can type the following:

status != Closed and issue IN linkedIssuesOf("status = Closed", "is delegated from") 

Not sure if you need to modify the 'is delegated from' part of the query with the other way around link description, something like 'delegates to'

 

I'll be really glad to further help you with your query, feel free to provide some images to underestand the current structure of your linked issues.

 

References:

 

Does it work for you?

Regards

Suggest an answer

Log in or Sign up to answer