nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Is there a way to run a report in Jira to show issues that were in the Sprint AT SPRINT START?

Isabella Musial

Scenario:
We have gone through planning, have 20 stories that we have planned. I hit the start sprint button. I want to see which stories were in the sprint at the time I hit the "start sprint" button. This will allow you to see what the original plan was, and compare that against what was added / removed during the sprint.

I tried using not in, but that didn't work.

Sprint is not EMPTY AND (issueFunction not in addedAfterSprintStart("Board Name") OR issueFunction not in removedAfterSprintStart("Board Name") AND issuetype = Story)

I know I can do this in EazyBI, but we've been told not to use EazyBI since it's slow and clogs up the network. So I am hoping that there is something like "issuefunction in committedAtSprintStart.

We have removed, added, complete and incomplete. Why not have "at sprint start'?

See: https://docs.adaptavist.com/sr4js/latest/features/jql-functions/included-jql-functions/sprint

Thank you in advance for your help!

Bella

Accepted answers

Isabella Musial

@Vix JIRA @Vix JIRA

Thank you for solving my issue! This worked, so far!

Planned, Removed, Added and Achieved:

https://community.atlassian.com/t5/Jira-Software-questions/I-want-JQL-query-to-get-story-point-Planned-amp-completed-in-a/qaq-p/2155835#U2606732

All comments

Isabella Musial

Could inSprint work? But will this know that the date "in sprint" was today?

inSprint(board name/ID or sprint name/ID)

Isabella Musial

NVM. Not available.

Nauris Malitis -eazyBI-

Hi Bella,

I’m Nauris from eazyBI.

I just wanted to share a couple of tips for eazyBI performance:

Use several smaller accounts with their own datasets (projects and issues) instead of one large account where everything gets imported. This allows you to run the reports faster as they analyze only the necessary data set.
For DC, set up a dedicated node for eazyBI: https://docs.eazybi.com/eazybi/set-up-and-administer/atlassian-server-and-data-center/dedicated-nodes-for-data-center
Increase the memory to 4 GB: https://docs.eazybi.com/eazybi/set-up-and-administer/atlassian-server-and-data-center/child-process
If you have eazyBI accounts with hundreds of thousands or millions of Jira issues, consider synchronizing with Clickhouse open-source analytical database that significantly improves analytical SQL query performance: https://docs.eazybi.com/eazybi/set-up-and-administer/atlassian-server-and-data-center/olap-dwh-database

If your admin/tech team has any additional questions, please let them know that they can reach out to support@eazybi.com with the setup details, and we’ll help identify any points of improvement!