I want to ask for a kind of JQL query.

[Jason Liu]

If issue A-1 is cloned by B-1, which was moved from A project to B project. And C-1 and D-1 are from project C and D. C-1 and D-1 have depend relation with B-1, as in issue link. How do I use one JQL query to search all the issues of B-1, C-1 and D-1?

[mauricio.groth]

Hi @Jason Liu 

As you're on Jira Server, the correct answer is to get an app that provides JQL extensions you're looking for.

With standard JQL, you can only get a list of issues and export them to Excel for further processing. This works if you want to do a one-off analysis. If your use case is more dynamic than that, look beyond standard Jira.

Standard JQL doesn't easily allow it, but you can quickly find the results using our professional indexing service JQL Search Extensions

Find issues that are blocked by issues from project A 

issue in linkedBy("is blocked by"  "project = A )

Also, you can use our function “links”, that search for issues that link issues matched by JQL

Find issues that link at least one issue from project JQL.  

issue in links("project = A”)

Check out the documentation for more examples.
I hope this helps!
Maurício

[Ollie Guan]

Hi @Jason Liu ,

hasLinkType issue function from ScriptRunner will give your answer.

https://community.atlassian.com/t5/Jira-questions/Is-it-possible-to-search-for-CLONED-issues-by-link-type/qaq-p/1055230