JQL Σ Remaining Estimate

[Erik Gotera]

Hi,

I am looking the way to search by Σ remaining estimate, because we make the estimation in the subtasks and we want to get the result of the following search in the parent issues:

Σ remaining estimate > 1d

Is possible? 

Thanks!

[Nic Brough -Adaptavist- · Accepted solution]

I'm afraid you can't do this natively.  Jira does not expose the  fields in search.  You'll need an add-on that provides a JQL function to do it (I've not seen one myself, but I'd use ScriptRunner to create one if I needed it.  Only because I've got SR experts on hand)

[Reg Hawkins]

https://jira.atlassian.com/browse/JRASERVER-69914
https://jira.atlassian.com/browse/JRACLOUD-25057

We have 2 suggestions outstanding relating to subtasks and I think as part of the requests the functionality you mention could be added

[Annie Charbonneau]

Hi Erik, 

Same issue here! Would love to see a solution for this.

Thanks in advance!

[Anna Bogdanova]

Hi Erik!

I faced to the same case, have you found solution to get Σ remaining estimate?

Thanks in advance!

[Milan Chheda [INFOSYSTA]]

Did you try:

remainingEstimate is NOT NULL

[Mohamed Benziane]

Hi Erik,

If you have Scriptrunner you can try two function on your jql query:

hasSubtasks()

or

issueFunction() 

Regards

Hope this helps

[Erik Gotera]

Hi Mohamed,

Thanks for the reply but I don't understand what you try to say me with that.

In the JIRA search, you can add a field call Σ remaining estimate where you can see in the parent issue the total remaining estimate of all the subtask.

I want to be able to make a query looking for that field.

Is possible? How?

Thanks!!!

[Mohamed Benziane]

HI,

Sorry for the misunderstood, can you try this 

remainingEstimate>1d

 Regards

[Erik Gotera]

Hi,

That is not working, because remainingEstimate is set when I log a work in the parent issue, but all the worklog are in the subtasks so the remainingEstimate that I see in the parent issue is the sum of all the subtask's remainingEstimate.

I realice that the remainingEstimate is different that Σ remaining estimate and I need to make a query with the second field.

Thanks

[Mohamed Benziane]

Hi,

OK it is why i asked you if you have scriptrunner because what you want is not implemented in JIRA JQL.

All my search send me to an add-on.

Regards