nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to get Issue History from API for all tickets marked "Done" with custom Ordering?

Ian Heagren

By trade I'm a Database Dev and haven't done much API work. I need to access Issue Key, two date fields (begin of in progress, date of when put into "Done"), and another custom field we created.

I need JQL can get me all the issues that are completed/done but to get the actual dates for status changes I need to hit the API.

I cannot use the db layer. This will run once a week and I will import into a on-premise db and put a BI tool we have access to on top.

Accepted answers

NotTheRealStephenSifersNOPENOPENOPENOPE

Hey Ian,

On your API URI you would append something like this:

(You will need to find your values for StartDate and DateDone, an API GET call on a sample ticket should give you the fields you need.)

?StartDate>=DATE+AND+dateDone<=DATE+AND+(status=done+OR+status=completed)

All comments

NotTheRealStephenSifersNOPENOPENOPENOPE

Hey Ian,

On your API URI you would append something like this:

(You will need to find your values for StartDate and DateDone, an API GET call on a sample ticket should give you the fields you need.)

?StartDate>=DATE+AND+dateDone<=DATE+AND+(status=done+OR+status=completed)

Ian Heagren

Thank you! This is what I was looking for.

NotTheRealStephenSifersNOPENOPENOPENOPE

Glad to help, if this helps to answer your question please accept my answer as the solution.

Let me know if you have any more JQL questions as well, always fun to practice.

Ian Heagren

I'll be doing this in the next couple of days and will mark accordingly.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

server

jira

jira-server