How to query and export recent comment?

[Arvind Koswala]

Hi,

I have list of tasks and sub tasks. I am exporting the report to csv and converting to excel. Now, I get all tasks, and sub tasks in different order displaying when I export it. And also, all comments are showing in each task or sub task. I have the following questions, could you please help guiding on this, as I don’t see any query option?

1. I need to export tasks and sub tasks in order. I mean, there should be a task and below that sub tasks displayed in order, right now, tasks and sub tasks are exported here and there in different order.

2. I need to export only the last update comment when I export it, not all comments .

[Jayant Bhawal]

If you're comfortable touching some code for this, here's a nodejs script to do so:

https://stackblitz.com/edit/stackblitz-starters-tfdzrd?file=index.js

You will need to create a JIRA token however. Shouldn't take more than a minute to do so:

https://support.atlassian.com/atlassian-account/docs/manage-api-tokens-for-your-atlassian-account/