How do I query for subtasks that have time logged within a date range?

Guy Pontecorvo September 13, 2013

I want to find all subtasks being actively worked for a given time period. "Worked" as in the developer has logged time against them.

How do I detect whether time was logged for a subtask during a date range.

I have looked at updated or updateDate.

Does update refer to parent changes only?

Thanks

2 answers

1 accepted

1 vote
Answer accepted
Guy Pontecorvo September 13, 2013

Thank-you Jobin. Our Jira Admin just informed me we have the plugin. So I was able to use it to solve this problem:

project=Installer and fixVersion in ( "Inst_2013_R2_Sprint6") and type in ("Dev Activity") and issueFunction in workLogged("after 2013/9/10 by userName" )

Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 13, 2013

It is a different plugin but you got it right ;)

JamieA
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 13, 2013

;-)

It's the script runner plugin, in case anyone else has the same requirement.

0 votes
Jobin Kuruvilla [Adaptavist]
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
September 13, 2013

You can't do it without the help of plugins. JQL Tricks Plugin (paid) has a method, workLoggedBetween, which you might find useful.

Suggest an answer

Log in or Sign up to answer