JQL to find all issues that are cloned from issues in a specific project

[kristi gray]

I want to find all issues that are cloned from issues in a specific project, all issues where  issueLinkType = "is cloned by" AND the issue linked is in the a specific project. 

Example:

ISSUE-1234 has a link type of "is cloned by" and that ticket is in project XYZ, how would I find all issues similar to ISSUE-1234 that have a link type of "is cloned by" and those linked tickets are also in project XYZ ? 

I found the page below but still not getting what I want: https://sweetbananas.atlassian.net/wiki/spaces/JBP/pages/1182695732/linkedIssuesOf

TYIA

[Hannes Obweger - JXL for Jira]

Hi @kristi gray

if you're open to solutions from the Atlassian Marketplace, I think you should get pretty close using the app that my team and I are working on, JXL for Jira.

JXL is a full-fledged spreadsheet/table view for your issues that allows viewing, inline-editing, sorting, and filtering by all your issue fields, much like you’d do in e.g. Excel or Google Sheets. It also comes with a number of advanced features, including support for configurable issue hierarchies - either based on Jira's built-in parent/child relationships, and/or based on issue links.

What you could do now is to model a hierarchy based on is cloned by relationships, and then use JXL's filtering capabilities to narrow down to the issues you'd care about - for example like so:

Once you have your list of issues, you can work on your issues directly in JXL, trigger various operations in Jira, or export your issues with just one click.

Since you've tagged your question for Jira Server: As you may have heard, apps sales have ended for Jira Server. Are you planning to migrate to Data Center or Cloud? I'd strongly recommend that. If you need some more time, JXL is perfectly compatible with Jira Server; it's just that we need to generate a license for you. If the above looks interesting, just let me know, and I'll happily start a free trial for you.

Any questions just let me know.

Best,

Hannes

[kristi gray]

Close but not quite - I also found this resource, but cannot get their suggestion to work

[Nagabharana S]

Hello @kristi gray

Check this feature request below : 

1. JRACLOUD-41841

Currently, on the Jira platform, the feature to find the issue using the link type is being reviewed by the development team through this request: JRACLOUD-41841 - JQL function for showing all issues linked to any issue by a given issue link type