SQl query for all issues in status for given date

Any idea how to query list of issues in given status at given date?(e.g. all isuess in status "open" on given date or between two dates)
I have Jira 4.0.2 and therefore no possibility to use "was" JQL functionality. I prefer Oracle DB query.

Thanks a lot.

2 answers

2 votes
Daryl Chuah Atlassian Team Feb 18, 2013

Hi Martin

Would you mind to try this JQL : status = Open AND created >= 2013-02-17 AND created <= 2013-02-20

Hope it helps

Cheers :)

I believe this will return all issues "currently in status open" and created in given date. I would like to have list os issues which was in status open in past (given date), no matter in which status they are corrently. So it actually did not help.

Yes I know this one, but unfortunately I didn't have chance to check if it is retunring what I need. It is written for MySQL and it is little bit tricky to rewrite it to Oracle. I made it somehow, but still cannot get to wanted result. :/ I'll keep trying.

That site with sql query examples is not bad, but if the queries are commented more detailly it would be much more helpful. Sometimes I'm not sure what to modify as I have no idea what is actually stored in mentioned tables.

Suggest an answer

Log in or Sign up to answer
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Published Monday in Jira Software

How large do you think Jira Software can grow?

Hi Atlassian Community! My name is Shana, and I’m on the Jira Software team. One of the many reasons this Community exists is to connect you to others on similar product journeys or with comparabl...

639 views 6 12
Read article

Atlassian User Groups

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!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you