Advanced Filtering

Here is my current search string: project = CUS AND issuetype in (standardIssueTypes(), Bug, "Documentation Request", "Engineering Service Request", Interop, "New Feature", Question, "RMA Request") AND status in ("In Progress", Pending, "Under Review") ORDER BY priority DESC, updated DESC

 

Now I need to go through all of those that are found and see if there are any open Linked tickets within those found in the above filter. Is there anyway to do this? If so, how? I am not fluent in JQL. Thank you in advance. Also note. we are using a Hosted OnDemand instance of JIRA w/o plugins.

Here is my JIRA Version and etc:

JIRA v7.1.0-OD-05-006

Copyright © 2002 - 2016 Atlassian Corporation Pty Ltd.

The use of this product is subject to the terms of the Atlassian End User Agreement, unless other specified therein.

This product includes software developed by the Apache Software Foundation.

This product also includes the following libraries which are covered by the GNU LGPL license:

 

This product also includes code written by other third parties.

Additional details regarding these and other third party code included in this product, including applicable copyright, legal and licensing notices, are available in the "licenses" directory under the JIRA installation directory.

License Information for JIRA Plugins

 

Portfolio for JIRA v1.11.3-OD-001-D20160113T192732

 

Copyright © 2014 Atlassian Corporation Pty Ltd.

The use of this product is subject to the terms of the Atlassian End User Agreement, unless other specified therein.

This plugin includes software developed by the Apache Software Foundation.

 

This plugin includes the following libraries covered by the GNU LGPL license:

 

This plugin also includes code written by other third parties.

Additional details regarding these and other third party code included in this plugin, including applicable copyright, legal and licensing notices, are available in the "licenses" directory inside the plugin.

 

 

 

JIRA Service Desk v3.1.0-OD-11-002-D20160113T081536

 

Copyright © 2002 - 2013 Atlassian Corporation Pty Ltd.

The use of this plugin is subject to the terms of the Atlassian End User Agreement, unless other specified therein.

This plugin includes software developed by the Apache Software Foundation.

 

 

This plugin also includes code written by other third parties.

Additional details regarding these and other third party code included in this plugin, including applicable copyright, legal and licensing notices, are available in the "licenses" directory inside the plugin.

 

 

 

JIRA Agile v7.1.13-D20160114T224659

 

Copyright © 2002 - 2013 Atlassian Corporation Pty Ltd.

The use of this plugin is subject to the terms of the Atlassian End User Agreement, unless other specified therein.

This plugin includes software developed by the Apache Software Foundation.

 

 

This plugin also includes code written by other third parties.

Additional details regarding these and other third party code included in this plugin, including applicable copyright, legal and licensing notices, are available in the "licenses" directory inside the plugin.

 

 

1 answer

1 accepted

Try this JQL statement to get issues which have linled issues with specified status: issue in (linkedIssuesHasStatuses("Done"))

@Vasiliy Zverev

Here is what I am getting:

Here is the Statement I added: project = CUS AND issuetype in (standardIssueTypes(), Bug, "Documentation Request", "Engineering Service Request", Interop, "New Feature", Question, "RMA Request") AND status in ("In Progress", Pending, "Under Review") ORDER BY priority DESC, updated DESC issue in (linkedIssuesHasStatuses("Open"))

here was the error: Error in the JQL Query: Expecting ',' but got 'issue'. (line 1, character 257)

When only running:(linkedIssuesHasStatuses=("Open"))
I get: Field 'linkedIssuesHasStatuses' does not exist or you do not have permission to view it.

Please advise, as it is like this "linkedIssuesHasStatuses" command is not understood in my JQL version/environment

You should not use "=", "linkedIssuesHasStatuses" is a function and "Open" is function paramenter.

Use this :

issue in (linkedIssuesHasStatuses("Open"))

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

288 views 0 12
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot