Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

JQL createdDate <= worklogDate?

Philip Heijkoop _ALM Works_
Atlassian Partner
May 30, 2018

I'm trying to use JQL to see if an issue has work logged. Simply filtering on work logged doesn't seem to be possible with JQL, however, I do have access to worklogDate, which will tell me when last work was logged. However, when no work has been logged, it seems to default to the creation time of the issue. So I would like to filter based on createdDate and worklogDate. I can do them separately to see if an issue was worked on or created in the last year, but I can't seem to equate or compare them in my query. Can anyone help out or point me in the right direction?

1 answer

0 votes
Meg Holbrook
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.
May 30, 2018

Would this work for you?

 

timespent is not empty

Philip Heijkoop _ALM Works_
Atlassian Partner
May 31, 2018

Hey Meg,

I'm afraid that doesn't work. timespent isn't the same as work logged for me. But `worklogged is not empty` also doesn't do the trick I'm afraid.

Meg Holbrook
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.
May 31, 2018

Hey Philip, 

It's too bad that the timespent won't work in your situation. I've scanned the forums and other sources for information on this question, and most responses have indicated you will need to install a time tracking addon like Tempo or Timesheet Reports and Gadgets. 

JQL is great, except for when it's not. Fortunately, Atlassian is always working on improving it. 

Sorry I couldn't help you out more! 

Philip Heijkoop _ALM Works_
Atlassian Partner
May 31, 2018

No worries. I was afraid I couldn't make it work with vanilla JQL. 

Thanks anyways.

Suggest an answer

Log in or Sign up to answer