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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.