Create
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Products
See all
Community resources
Top groups
Explore all groups
Community resources
Learn
Community resources
Events
Community resources

SQlServer Query for Changed FROM Resolved TO Reopened

Vishnuteerth Ibharampur
Vishnuteerth Ibharampur January 3, 2018

SQlServer Query for getting Issues Changed FROM Resolved TO Reopened
and  Closed to Reopened from givendate

Answer
Watch
Like Be the first to like this
191 views

2 answers

0 votes
Alexey Matveev
Alexey Matveev
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
Get recognized
January 4, 2018

Why JQL query is not enough for you? It would be like this

status changed from Resolved to Reopened during ("date1", "date2")

You could also pass the JQL query to REST API call (search method) and get all issues which satisfy the condition. It would be a much cleaner solution.

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

Reply
0 votes
Nic Brough -Adaptavist-
Nic Brough -Adaptavist-
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
Become a leader
January 4, 2018

SQL is the single worst possible way to report on Jira, please do it properly with the UI or API.

If you insist on doing it the wrong way, look in the changeitem table, which you'll then need to join to at least two other tables just to get the basics out.

Reply

Suggest an answer

Log in or Sign up to answer
Jira
Jira Software
TAGS
AUG Leaders

Atlassian Community Events

    See all events