Query issue history

[BlueKai Support]

Hi, is it possible to query issue history?

"changed" and "was" JQL functions don't work for custom fields, like dates. Is there a way to get to that data?

Use case:

We want to see all stories with a changed ship date. This is for Product and management, as dates can change for many reasons. If anyone else has creative ways to answer this, that'd be appreciated.

I was als trying to query for story tickets that were in previous sprints?

[Pablo Beltran]

The SQL for JIRA plugin supports it. Please, notice that it is capable of combining SQL and JQL:

select 
     i.key, c.created, c.toValue
from 
     issues i
left join
     issuechanges c on c.issueid = i.id
where 
     i.jql = 'type = Story'
     and c.field = 'Sprint' 
     and c.fromvalue = 'Some Sprint'

In the query above, issues are filtered by using the jql = 'type = Story'. Once all the stories have been fetched, they are filtered by having a 'Sprint' type filed in the change story and having a initial Sprint value = 'Some Sprint'

It would return the issue key and the date of the change as well as the new Sprint value.