How can I search the task which has multi 'sub-task' via JQL or SQL?

Nate (이슬기) [Project Management] ­

Guys, I have a question related to JQL(or SQL)

 

Is there any way to search the tasks which has below condition?

1. The task which has 'sub-tasks' more than 2

2. The task which has the link 'is related to' more than 2

 

is it possible to search via JQL or SQL?

Piotr Bojko

with this plugin https://marketplace.atlassian.com/apps/1218767/smart-ql?hosting=server&tab=overview

 

you can do following query

select aux.ASISSUEKEY(IL.SOURCE), count(il.DESTINATION) 
from ISSUELINKS IL where name = 'Relates' or name = 'jira_subtask_link'
group by IL.SOURCE HAVING COUNT(IL.DESTINATION) > 2