JQL - How to filter stories spilled over multiple sprints?

[Sanjog Sigdel]

Hello Community,

I tried this query to list the stories moved over two sprints 510 and 511

project = "Project Name" AND issuetype = Story AND Sprint CHANGED during( "510" TO "511")

But Jira shows following error:-

• History searches do not support the 'sprint' field.
• The value '510' does not exist for the field 'sprint'.
• The value '511' does not exist for the field 'sprint'.

Have any of you used the filter to list stories spilled over iterations? If yes can you please suggest my how to do the right query?

Thank You

[Mikael Sandberg]

It's stored in the database in the cwd_directory_attribute table.

[Harish Tuccapuram]

Thanks @Mikael Sandberg by chance do you know the query for that, i am poor at writing the SQL queries.

Thanks!

[Mikael Sandberg]

SELECT [directory_id]
 ,[attribute_name]
 ,[attribute_value]
 FROM [cwd_directory_attribute]

This is for MSSQL, dependent on what directory you want the information for you need to look in the cwd_directory first to figure out the directory id first. You could then run something like this to only see the attributes for the specified directory:

SELECT [directory_id]
 ,[attribute_name]
 ,[attribute_value]
 FROM [cwd_directory_attribute]
 WHERE [directory_id] = 1

Note that these queries are not complete, the FROM statement is missing the database and schema, those are dependent on your environment.