Need to search by and order sprints in a particular cadence

Samantha Sileski_25pv18

Hi!

We have Jira Cloud and ScriptRunner

Our sprints are prefaced by Team NAME - and all run on the same cadence.

So, abc-SP-06 and 123-SP-06 run in the same two week period.

I need a query that allows the data to be returned in order. ie.:

abc-SP-06

123-SP-06

abc-SP-07

123-SP-07

etc. 

Not all items in sprints have planned Start, etc. and this needs to be forward looking.

Is this possible?

Trudy P Claspill

Hello @Samantha Sileski 

The short answer is there is not a native method to do what you want.

Jira JQL does not include a "Group by" option, only and "Order by" option.

Additionally the Sprint field for an issue will contain all the sprints to which the issue was ever assigned and not explicitly removed. Even trying to order the data based on the Sprint field when the field contains more than one value is not clear.

In my own environment where I have some issues with only one value in the Sprint field and other issues with multiple Sprint values, I could not discern the logic being used by Jira when I added "ORDER BY Sprint ASC" to the JQL statement. It looked like the issues were being order by the underlying, instance-wide, unique numeric ID associated with the Sprint value, with those IDs being assigned to sprints sequentially as they are created in Jira. It definitely was not based and the human readable name assigned to the sprint. And it was unclear which value for which sprint was used in the sorting when the Sprint field contained multiple values.