JQL for find all issues have linked issues which linked issues are assigned to me

[Nuwan]

how to write a JQL for find all issues that have linked issues (linked issue type let say "story") and these linked issues are assigned to me.

[SanaS]

Hi Nuwan,

You need Scriptrunner for this; with it you can use a neat JQL function:

issueFunction in linkedIssuesOf("issuetype = story and assignee = currentUser()")

[Pablo Beltran]

With SQL for JIRA:

issue in sql("
	select *
	from issues i1 inner join issues i2 on i2.id=i1.parentid
	where i1.JQL='issuetype = story and assignee = currentUser()'
")