Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
Community Members
Community Events
Community Groups

Can I get all the details of all the tickets which were assigned to me from a particular account?

Can I use the API of jira to get the details of all of my tickets e.g. How many tickets I have done, How much was the average time, difficulty level of my tickets etc. 

1 answer

0 votes

Hello @asad_ullah_beg ,

Thanks for reaching out and welcome to the community, and depending on exactly what you are looking for, I believe the issue search endpoint using a JQL with something like "assignee=currebtuser()" should do the trick to pull the issue data, and then it would be down to scripting something to parse the issue data returned to get the calculations.  Check out the Doc here:

However, Something that I believe would work a lot easier and be a lot more flexible than custom scripting over the API would be to use either the Jira Cloud for Excel (official)  or the Jira Cloud for Google Sheets (Official)  connectors to do a Similar JQL pull on the data and then use the native spreadsheet toolset to build out a report based on the values returned, 

As an example you noted that you want to know how many tickets you have done, this would give you the ability to do things like a count on all issues returned where status is done.  Quick example in google sheets would be if the status column was in column B using a query like "=countif(B:B,"done")" could do the trick.


The complexity of tickets would be a bit trickier, as you would need to define the criteria of complexity means, and then decide on a weighting system of how to record complexity, like looking at the story points, or a number of bounces, or priority/SLA's, etc... but once you define what the complexity criteria, it would be down to using the defined weighted values to build out a reference to ticket count per complexity value.

Hope this helps you get on the right track.


Suggest an answer

Log in or Sign up to answer

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