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

This widget could not be displayed.
Vasiliy Zverev Community Champion Jan 19, 2016

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

Vasiliy Zverev Community Champion Jan 21, 2016

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

Vasiliy Zverev Community Champion Jan 21, 2016

Use this :

issue in (linkedIssuesHasStatuses("Open"))

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published yesterday in Marketplace Apps

The 7 hacks of highly successful automation

...there's anything I've learnt from working, it's that people are lazy! No offense to anyone reading this, but it's true and we can all admit it. The easier you make something for someone, the more...

81 views 0 8
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