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

[Raunak Gupta]

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]

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]

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