JIRA jql - query to extract parents with the subtask and its last comment

[Cezary S.]

Hello,

I'm struggling for quite a while with a jql query which will extract desired values. This is my structure:

Parent I

• sub-task called "test"
  • last comment of the subtask

Parent II

• sub-task called "test"
  • last comment of the subtask

...

To ease the case, subtasks I want to extract have always the same name. Now, what I want to get is :

Parent Key | Parent Name | Last comment from the sub-task with given name |

I tried several attempts but none of them works for me (script runner available). Please help.

[Henning Tietgens · Accepted solution]

You could create a scripted field for the parent issues which holds the last comment of the subtask and add this as a column to the issue navigator.