Filter Jira issue based on Sumup field?

Vinay Shekar

We have a Sumup field in our Jira instance by name "Σ Time Spent".

Now we need to write JQL Query to display all issue with "Σ Time Spent" >=20h.

But I don't find that field while writing JQL Query.

Please advise.

Thanks
Vinay

Daniel John

Hi Vinay,

 

the field "Σ Time Spent" is not searchable. So you can't use it in a JQL Query. The field "Time Spent" is searchable.

 

Workaround:

You can use ScriptRunner to create a ScriptedField with the same content as the field "Σ Time Spent".

 

The script of the field looks like:

 

import com.atlassian.jira.component.ComponentAccessor;
import com.atlassian.jira.issue.util.AggregateTimeTrackingCalculator;
import com.atlassian.jira.issue.util.AggregateTimeTrackingCalculatorFactory;
AggregateTimeTrackingCalculatorFactory timeTrackingCalculatorFactory = ComponentAccessor.getComponentOfType(AggregateTimeTrackingCalculatorFactory.class);
AggregateTimeTrackingCalculator calculator = timeTrackingCalculatorFactory.getCalculator(issue);
if ( !issue.isSubTask() )
{
	return calculator.getAggregates(issue).getTimeSpent();
}
return 0;

 

Now you can configure the right searcher "Duration searcher" for this field:

 

Admin > Issues > Custom Fields > Edit

 

image2016-4-7 9:58:18.png

 

Afterwards, you are able to define a JQL with that field:

image2016-4-7 9:59:51.png

 

Hope you enjoy our add-on!

Have a nice day!

 

Best regards,

Daniel John

image2016-4-7 9:59:51.png

image2016-4-7 9:58:18.png