JQL createdDate

Question

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?

Philip Heijkoop _ALM Works_ · Answer

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

Thanks anyways.

Meg Holbrook · Answer

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_ · Answer

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.