Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Extract date and time when status changed

I would like to extract a list of date and time when tickets within a certain project changed from "open" to "in progress" which can be clearly seen in the history.

 

project = $projectname AND issuetype = "$issuetype" AND status changed to "$state" during ("2018-01-10","2018-01-11")

 

With this search, I can only see the list of tickets but I am interested to extract the data within each of the tickets.

2 answers

0 votes
Thomas Deiler Community Leader Feb 13, 2018

Dear @Gamesys,

the information you are looking for, is stored in the history only, that will not be displayed as a search result.

You could query the REST API, to extract the dates, when the transition from 'open' to 'in progress' was made.

Are you familiar with the API?

So long

Thomas

Yes @Thomas Deiler and currently I am using:

 

https://$HOST/rest/api/2/search

 

However it is only extracting the content within the ticket itself and not inside the history or transitions.

Thomas Deiler Community Leader Feb 13, 2018

Dear @Gamesys,

you have to expand the history:

/jira/rest/api/2/search?expand=changelog

So long

Thomas

Thanks @Thomas Deiler. Yes I am trying to extract the information using the changelog and also tried using the expand=transitions.fields but failed to extract the fields I am interested in:

 

{"expand":"names,schema","startAt":0,"maxResults":50,"total":1,"issues":[{"expand":"operations,versionedRepresentations,editmeta,changelog,renderedFields",

Thomas Deiler Community Leader Feb 13, 2018

Dear @Gamesys,

I just performed a

https://server.de/rest/api/2/search?jql=project=TST&expand=changelog

and got some issues back:

The history can be found in:

issues>expand>changelog>histories>items

There you have to look for an entry with status change. Then you can take the date of the history.

So long

Thomas

Like Shantanu Sharma likes this
Thomas Deiler Community Leader Feb 19, 2018

Dear @Gamesys,

have you been successful with extracting your fields?

So long

Thomas

Hi Thomas

Do we have any links/material to understand REST Api's in jira ?

Thanks in advance

Thomas Deiler Community Leader Aug 30, 2018

Dear @vivek_karn,

for the details you get in the JSON response, it's best to explore them on your own with a Rest explorer/client. Not all possible combinations can be found in the documentation. The variations are to huge. But after you have seen some JSONs you will get familiar with the format.

So long

Thomas

Dear @vivek_karn ,


Sorry to say, there is one way to understand jira api 

you have to read jira API documentation

https://developer.atlassian.com/cloud/jira/platform/rest/v3/#api-rest-api-3-search-get

 

Thanks,

Dear @vivek_karn ,


Sorry to say, there is one way to understand jira api 

you have to read jira API documentation

https://developer.atlassian.com/cloud/jira/platform/rest/v3/#api-rest-api-3-search-get

 

Thanks,

Suggest an answer

Log in or Sign up to answer
TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you