Advanced Filtering

Jeremy R. Bailey January 19, 2016

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

1 vote
Answer accepted
Vasiliy Zverev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 19, 2016

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

Jeremy R. Bailey January 19, 2016

@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)

Jeremy R. Bailey January 21, 2016

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
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 21, 2016

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

Vasiliy Zverev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 21, 2016

Use this :

issue in (linkedIssuesHasStatuses("Open"))

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events