Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in
Celebration

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root

Avatar

1 badge earned

Collect

Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!

Challenges
Coins

Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.

Recognition
Ribbon

Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!

Leaderboard

Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,458,298
Community Members
 
Community Events
176
Community Groups

How can I run a query which will find the stories which have updated story points for a given day

I want to pull a report which would tell me which stories have updated story points for a given day/timeframe, Can I do this?

3 answers

1 vote
Mark Segall Community Leader Dec 13, 2022

Hi @Maria Tripodi and welcome to the community!

Unfortunately, this is not something you will get by way of JQL.  Jira only offers a few fields that can be queried for history changes.  However, if you're looking for issues that have changed story point value in sprint, you could use the native sprint report.

Otherwise, your best bet would be to leverage a custom date field and automation that would look something like this:

  • TRIGGER: Field Value Changed (Story Points)
  • ACTION: Edit Issue (Your custom date field)
    • {{now}}

Then you'd be able to execute JQL like this:

YOURCUSTOMFIELD >= -3d

OK - thanks. I am not sure if that will be helpful for what I am trying to achieve.

What do you want to achieve? Knowing the goal we might be able to help you figure something out :)

0 votes
yuliia_b__SaaSJet_ Marketplace Partner Dec 13, 2022

Hi @Maria Tripodi 

What hosting type do you use?

You can check story points updates with the Sprint report or Sprint Burndown chart.

If you are on Cloud, you can try Issue History for Jira add-on. My team has developed it as a journal for all past changes.

Here you can filter issues by date or date range and check if story points were updated.

Story points changes jira.png

Disclaimer: marketplace partner!

Hey @Maria Tripodi -

If you are open to a 3rd party we support this in minware. Below is a screenshot from our Value Stream Report - this instance is grouped by ticket and I've set the date range to show activity from 11/27-11/30 but you can adjust the dates as you see fit. You can group this information differently if you'd like (Author, Epic, Sprint, Repository) and also apply the filters that you see in the upper right:

 

minware value stream by ticket.png

Each ticket can be expanded to show the work that went into it - all the way down to the individual commits:

minware value stream by ticket 2.png

We offer a free trial if you want to check it out!

Suggest an answer

Log in or Sign up to answer