JQL Search with timespent to include subtasks' timespent

[Pan Wong]

We were using timspent as a filter to see all stories that has time spent. However, it seems like the JQL search for timespent doesn't include the subtasks' timespent. Is there a way to write a JQL that will include them.

For example, I have a story and it has many subtasks. We have timespent in all the subtasks and even shown in the column timespent, but where we use timespent is not empty, it filters out the story.

Thanks in advance.

[Jobin Kuruvilla [Adaptavist] · Accepted solution]

You can't do this on onDemand. In the downloaded version, there are few plugins that will help.

[Pan Wong]

Okay, thanks, I found one for example, JQL Trick Plugin, https://marketplace.atlassian.com/plugins/com.j-tricks.jql-plugin. Somene should come up w/ one for onDemand

[Jonathan Demeyer]

Which plugins ? JQL Trick seems no to be maintened anymore.

Thanks

[Gulfam Amin ul Haq]

Script runner can be used
issueFunction in workLogged( "after 2014-08-01", "before 2014-08-30" )

*JIRA Timesheet Reports and Gadgets (http://www.jiratimesheet.com/wiki/Overview.html)<br< a="">>issue in workedIssues("2014-08-01", "2014-08-30", "jira-users")

or if using the timespent variable you can add the Sum time spent column to show all the time loffed agains the parent items