Creating custom JQL query to get number of story points assigned to a user after sprint starts

Facundo Calderon

Hi folks!

I have a rather niche question. I'm trying to create a JQL query to give me the number of story points added to a user after the sprint starts. For context, team members start with a set number of story points per sprint, but as they finish, they are to grab tasks from the unassigned list.

I essentially want to get a definite number on how many story points are added  to a team member after the sprint starts without having to manually keep records of how many story points they started with vs. how many they finished at the end of the sprint.

 

I have tried to find solutions for this but I can't seem to work out how to filter the added story points by users.

 

Any ideas? Thank you! 

Bill Sheboy

Hi @Facundo Calderon -- Welcome to the Atlassian Community!

Ignoring for the moment the question of why members of a team using the scrum framework would have assigned story points per sprint...(you can discuss that with your team and scrum master or agile coach).

JQL has a CHANGED operator which can be used with the assignee field: https://support.atlassian.com/jira-software-cloud/docs/jql-operators/#CHANGED With that, you could make a query to find this information:

project = myProjectName
 AND sprint in openSprints()
 AND assignee CHANGED AFTER "enter your sprint start date here"

That could be reported on a dashboard, or you could filter further by specific assignees.

Kind regards,
Bill