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

[Isabella Musial · Accepted solution]

@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 

[Nauris Malitis -eazyBI-]

Hi Bella,

I’m Nauris from eazyBI.

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

1. 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.
2. 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
3. Increase the memory to 4 GB: https://docs.eazybi.com/eazybi/set-up-and-administer/atlassian-server-and-data-center/child-process
4. 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!

Have a beautiful day!

Nauris

[Isabella Musial]

Thanks! Unfortunately our organization has removed EazyBI option, which is a bummer. I loved having the ability to customize my reports! 

[Nauris Malitis -eazyBI-]

That's a bummer indeed :(

If you're company decides to give it another shot, feel free to reach out to us and we'll help you set it up in the most efficient way :)

Have a great weekend!

Nauris

[Isabella Musial]

I do miss the power of EazyBI - just not the slowness. ;) 

[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.