How do I find all stories marked completed by one person in a certain time range

[Jane Tran]

I'm trying to write a query to find stories marked complete by one person from January 2023 to current.

[Mark Segall · Accepted solution]

Hi @Jane Tran and welcome to the community!

You could do something like this:

issueType = Story and status changed TO YOURSTATUS BY USER AFTER startOfYear()

[Jane Tran]

Thank you @Mark Segall! JQL is so interesting.

How would i add a story point count to this query? To filter our the amount of story points this individual completed this year so far.

[Mark Segall]

Apologies, but I'm not quite sure I understand the question.  Are you trying to return results where the stories have no story points or are you looking for total story points for the year?

If the latter, you're not going to get totals from the JQL, but you could export it.  And for that scenario, I'm thinking you want a different type of query where it's based upon the assignee and when it was resolved which would be...

assignee = YOURUSER AND resolved >= startOfYear()

This assures that you're getting by who was assigned rather than who closed it which may have been a different individual.  From there, I would make sure the search results include Story Points as a column and then select Export >> CSV (Current Fields)

I hope this helps