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 Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Bridget Sauer
Published yesterday in Marketplace Apps

Calling all developers––You're invited to Atlas Camp 2018

 Atlas Camp   is our developer event which will take place in Barcelona, Spain  from the 6th -7th of   September . This is a great opportunity to meet other developers and get n...

71 views 0 5
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