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

Cezary S. January 14, 2014

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.

1 answer

1 accepted

2 votes
Answer accepted
Henning Tietgens
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
January 14, 2014

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.

Suggest an answer

Log in or Sign up to answer