The Atlassian Community Forums are currently in read-only mode. We will be relaunching on a new platform on September 22 (read more here). We apologize for the extended downtime. For concerns or questions, please email communitymanagers@atlassian.com. See you on the other side, on the new Atlassian Community Forums! :)

×

Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Add More detailed columns to a Filter/View

Michael Berry
April 21, 2020

I am looking at a default view/filter that shows typical Issue information, such as 
ID, Status, CreateDate, UpdatedDate, ResolvedDate, etc.  The Status always represents the current status of the Issue.

I need to see the individual timestamp dates for when the Status actually changes.

For example, an Issue uses the following Status Cycle:
Created > Reviewed > Approved > Resolved.  I need to see the Timestamps/dates for each of the Status workflow steps, and the User who updated the Status  I do not care about the 'LastUpdated' date.  

EDIT: After more research, I guess I am looking to export the Transitions/History information for all Issues in a project.


Can I get to this information in Jira with paying for 3rd party "apps"




1 answer

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

0 votes
Mohamed Benziane
Community Champion
April 22, 2020

Hello @Michael Berry 

Welcome to the community.

You can use the API to find the informations you need.

This api return all the changelog for the issue

GET /rest/api/3/issue/{issueIdOrKey}/changelog

 

I'm not aware if there is an addon for this. You can take a look at the marketplace to find and test one

 

Hope this helps

Michael Berry
April 22, 2020

Thank your for trying to help @Mohamed Benziane 
Based on your link I can ask a better question:

What I need is :

Get transitions

GET /rest/api/3/issue/{issueIdOrKey}/transitions

Specifically I need to return ALL transitions, for ALL Issues in a project with UserName and timestamps for the Transition Data.  I would need instructions to create this dataset in a Jira Filter in a non-paginated format, or possibly in a MS PowerQuery.

Simply, how would i get a flat Jira dataset that would show IssueID, TransitionName, DateofTransition?

Atlassian Marketplace solutions are not of any interest.

TAGS
AUG Leaders

Atlassian Community Events