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 · Accepted solution]

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