Should we have different sprints for different projects or a single one for all proejcts?

[Sanjog Sigdel]

In my previous organization, there used to be separate sprints for individual projects. The common understanding was that we follow an Agile Release Train and the sprint opening and close date was constant over all ARTs.

In my new organization there is one single sprint for all scrum projects. Now one of my scrum team's release is taking more time so the sprint close will happen in next day. This is an exceptional case because of business priority in terms of value delivery. But other scrum teams can't start next sprint and estimation since the sprint is not closed.

Please educate me on the standard practice and how to handle the scenario. Should we have a single sprint or keep separate sprint for separate teams?

[Andy Heinzer · Accepted solution]

You can probably find this information in SQL with a query like this:

select cfv.issue, cfv.stringvalue, cf.cfname, P.PKey || '-' || issue.IssueNum as IssueKey
from CustomFieldValue cfv 
join CustomField CF on CF.Id = CFV.CustomField
join jiraissue issue on issue.id = cfv.issue
join Project P on issue.Project = P.Id
where P.pkey='SCRUM' and cf.cfname='text1';

This works in postgresql, but the syntax might be different for other database types.  In my case my project key here is called 'SCRUM' and my custom field name is 'text1' (both without quotes.

[Olexandr Polinkevych]

Thank you a lot, that's exactly what i need!

[Piotr Bojko]

@Olexandr Polinkevych what does this mean "without checking permissions"? You want to get a specific data despite in JIRA you do not have access because of permissions to them?

[Olexandr Polinkevych]

Yes, i do.

[Nic Brough -Adaptavist-]

This is a horrible way to get data from Jira, please consider doing it properly instead.

But, if you must, then you will need to join Project (or hard-code the specific project), customfield (or hard-code it again) and customfieldvalue with Jiraissue to find it.  It will also be inaccurate if config has been changed in certain ways, and it will ignore any permissions and security.

[Olexandr Polinkevych]

can you provide an example of query pls?

[Nic Brough -Adaptavist-]

It will be quicker for you to work it out for myself.  I would never do it this way, so I've got nothing to hand.