JQL Query

[Rhiannon Miller]

I'd like to exclude proposal and contractual request tickets whose parent ticket is closed. You can see on the attached image the filter has returned a proposal request for which the associated sales ticket is closed. My current filter query is:

(project = .sales. OR project = "Client Services") AND Bid-Manager in (yhiggsmith, pneale, halsaadi, rmiller, ldadson, jchai) AND Status in (Suspect, Lead, Prospect, "Proposal Out", Verbal, "With COPS", "Ready for Review", "With Customer", "In COPS Review", "OPS Governance", "In Progress", "In Review") AND status != Closed OR "Project Manager" in (yhiggsmith, pneale, halsaadi, rmiller, ldadson, jchai) AND Status in (Suspect, Lead, Prospect, "Proposal Out", Verbal, "With COPS", "Ready for Review", "With PS Team", "With Customer", "In COPS Review", "OPS Governance", "In Progress", "In Review") AND status != Closed ORDER BY key ASC, Rank ASC

This is probably a housekeeping issue moving forwards but to work with what we have right now it would be good to be able to exclude these instances.

[Bill Sheboy · Accepted solution]

Hi @Rhiannon Miller  -- Welcome to the Atlassian Community!

Focusing on the problem you noted: exclude issues from the board when the parent is in a particular status...

That is not possible with out-of-the-box JQL, as it is not a SQL and does not have such features.  You would need a marketplace addon to do so.

And also...you note not wanting to see such issues.  Why are the child issues still open when the parent is closed?

• If this is an error and the child issues should have been closed, you could investigate using an automation for Jira rule to close the children when a parent closes
• If instead when the parent closes, the children are now independent (or have a new parent) consider how to alter that relationship in the issues.

Kind regards,
Bill

[Rhiannon Miller]

Hi Bill,

Thanks for your response. Systems I've used in the past have closed down the child tickets when the parent ticket closes, which makes sense, but perhaps there's a reason these haven't closed. I'm relatively new to the software so maybe I need to ask our admin some clarifying questions.

Thanks again!

Rhiannon

[Nic Brough -Adaptavist-]

For my 2p worth, I know exactly what you're working with, it's a very old project that has been completely mis-handled over many years and is very poorly configured.

I've never been allowed admin on that system because I'd have burned it with fire.

You have colleagues working on binning it and getting something better in place already, we've already decided not to bother making even more changes to it as it is.

[Daniel Turczanski - JQL Search Extensions · Accepted solution]

Hi,
With standard JQL, you can only get a list of issues that have a particular issue link type:

issuelinktype="included in sales opportunity"

As a next step, you can use our app to find only the issues that have dependencies that are still not done:

issue in linkedIssuesOfQuery("resolution is empty", "includes in sales opportunity")

Check out the documentation if you want to know more.
I hope this helps!
Daniel

[Rhiannon Miller]

Thank you!