Come for the products,
stay for the community

The Atlassian Community can help you and your team get more value out of Atlassian products and practices.

Atlassian Community about banner
4,297,053
Community Members
 
Community Events
165
Community Groups

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

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

Like mahdielmasaoudi likes this
5 votes
Deleted user Jul 10, 2015

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 smile

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 

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

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

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

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. 

Comments for this post are closed

Community moderators have prevented the ability to post new answers.

Post a new question

TAGS

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you