I need to get rid of Sub-tasks, and I would like to place comments from existing sub-tasks to the parent issues. I noticed that comments are not exported to Excel, but can be exported to World which is not very usefull.
Could you please advise where I can start from in order to export comments?
Best regards, Georgiy
You can use JIRA Command Line Interface to export all comments for a project (xxx) to CSV:
jira -a runFromIssueList --project xxx --common "-a getCommentList --issue @issue@ --outputFormat 2 --append --file xxx-comments.txt"
or subset the runFromIssueList with JQL search term to only do only subtasks.
From there, you can process the CSV with your favorite scripting language (like groovy :)) using addComment to add the comments back in. Unfortunately, because of limitations of JIRA, the comments get added with the current date and script user id.
could you please advise what format to use in order to get Sub-Tasks field from parent issues?
I tried following comand with output formats 2,200,998,999, but could not get Sub-Tasks field
jira --action getIssueList --append --file output.txt --search "issueKey=issue-1 or issueKey=issue-2" --outputFormat 200
Thank you Bob for advise! Actually my intention is to have output file which contains following fields
Key;Issue Type; Fix Version/s; Custom_field1; Custom_field2 ;Original Estimate;Remaining Estimate;Time Spent;Sub-Tasks
because I will use such file to find what comments should be written from sub-tasks to parent issues.
Do you know whether it's possible to vary output format for searched queries?
There is no option to export comments to Excel now.
The best solution here is to do it in the database. You need to replace the subtask ids in jiraaction table with that of its parent ids.
Try it in the Test environment only first;)
If you are not comfortable touching DB, go for a simple servlet which copies those comments over.
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
We're bringing product updates and pro tips on teamwork to ten cities around the world.Save your spot