JQL on work logged

Hi There

Is there a way to get a list of JIRA issues with work logged on a specific date ?

I use JIRA 5.1.3, 5.2.4 and 6.0.4. I can't afford a plugin for this.

Thanks, Vishnu.

4 answers

1 accepted

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

1 vote

Answer accepted

This has been asked before: https://answers.atlassian.com/questions/47652/jql-jira-filter-on-worklog

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

It doesn't help me. But thanks for the answer.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Like • mahdielmasaoudi likes this

5 votes

Hey Vishnu,

Assuming you have the most recent version of Jira, the following should work for you...

Today:

worklogDate = endOfDay()

Specific date:

worklogDate = "2015/07/10"

Note: Valid formats include: 'YYYY/MM/DD', 'YYYY-MM-DD', or a period format e.g. '-5d', '4w 2d'.

Hope this helps

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Hi Carl

How can i get the work log time on that particular day , from the above script i am only getting the total of the work log for a particular task

i am looking for the actual work for the specified date, can any one provide info on this.

Thanks

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Did you find a way to do this? I need it too

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

I also would like to find out. Custom field maybe the answer to filter out the specified date portion.

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

1 vote

Hi Vishnu,

On JIRA 6.4, it will be possible to filter by worklogDate on the JQL queries:

https://jira.atlassian.com/browse/JRA-40973

Cheers,

Danilo

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Looks like ticket JRA-40973 didn't fix the issue. We want to be able to get the hours logged on the worklogDate provided in the JQL but the results give the total logged hours via field "Time Spent" on the Jira item. Ticket JRA-40973 did not fix the issue.

Please look at all the previous comments and the comments in ticket JRA-40973.