Need JQL query to get the parent tickets list based on child ticket's assignee

Question

Case: I have a few child tickets assigned to a team member. Looking for a JQL query that returns the list of all parent tickets for which any child ticket is assigned to that team member

Garrett McCreery · Answer

Hi Raunak.

You just need to show the "Parent" as a column. This will show you the parent ticket for all of the child tickets assigned to the team member you specify:

Mohamed Benziane · Answer

HI @Raunak Gupta

You will need an addon like Scriptrunner to achieve this

https://docs.adaptavist.com/sr4jc/latest/features/scriptrunner-jql-keywords-functions/enhanced-search-included-functions/subtask-functions