JQL query to detect Story Points estimate older than X days

[Kamil Zatorski]

Hello, I am looking for JQL query to detect Story Points estimate older than X days.

Using "update" is not beneficial here as it looks at all moves in the ticket, how to limit it to 'estimate activity' only?

[Tessa Tuteleers · Accepted solution]

Hi @Kamil Zatorski , 

welcome to the community. 

While it is possible to query on the history of a few Jira fields, "Story points" is not one of them. 

You can create a workaround however if you want to monitor this.
Apps like automation can make it easy to access the changes and can monitor on which field a change happens. If such a change happens, you could set a dedicated date custom field (e.g "Estimation date") and set it for every change against the field. 

You could query on that field easily. 

Hope it helps! 

- Tessa

[Kamil Zatorski]

Hi @Tessa Tuteleers

Thanks for prompt answer. I probably should add that I am not using standard "Story Points" field, but I am using custom field "Story point estimate" for estimating purpose. The value is always numerical. 

Does it change something?

So far I thoung about query that contains:

1. check if "Story point estimate" field IS NOT Empty
2. check if issue is in "Open" status
3. check if "Story point estimate" field was updated more than 3 months ago 

I know how to proceed with first and second point, but I don't know how to approach the third one..

[Tessa Tuteleers]

Hi @Kamil Zatorski , 

the same applies here, you can monitor the change of any custom field using Automation and add that date to the issue again. 

You could script it yourself or use other apps than Automation of course, but the basic idea will remain the same, you need to add the date on the issue to be able to query on it. 

Another way to look at it would be developing a custom JQL function. This method is described here.

- Tessa

[Kamil Zatorski]

Thank you Tessa, I will use the workaround proposed by you.