How to access worklog to access the time

[Deleted user]

So my basic requirement is that to get the worklog time in a ticket. I filter the tickets by newly updated, and i want to get the worklog time for each day.

Is there a way to do this ? using JQL perhaps ? because when I check the json which i get by jql there's no fields for that. 

Please advice.

[Nir Haimov · Accepted solution]

Hi,

In JQL you can filter by worklog and also add the worklog column to see the details.

The trick is that the fields called a bit different than what we might think and that is why some people make it hard to find them and work it.

Any way, here are the fields:

"Original Estimate" = shows you the original estimation you set for logwork

"Remaining Estimate" = shows you the remaining estimation remained for logwork

"Time Spent" = how many logwork logged.

For example, i set estimation of 5 days, i logged 1 day, so the remaining is 4 days.

I search for issues with more than 0 days estimation (which means, we set estimation for them) and someone logged time for them (time spent > 0)

[Deleted user]

Hi @Nir Haimov

Thanks for the reply, but however that's not quite what I want.  As an example, in below image, I want to get the time for each day that he worked on. So if i wanted to get the time he spent on for the OCT 1, it would be 55 mins. Rather than collection of all the he spent on that ticket.

[Nir Haimov]

Ohh, i see.
You can't do it in Jira jql.

You can script it with ScriptRunner or with rest api read all worklog.

[Deleted user]

I see, There's a pluging call TimeSheet on Jira market, I've been using it, However I want to write a script to do some specifics and take it further. 

In it, it perfectly breakdown the time for each day. Do you have any idea how it has been done there ? 

[Nir Haimov]

This plugin shows something they coded to extract the data and show it to you.

In order to do it your self you will have to code it, that's what i meant before when i said you will have to do some scripting.

[Deleted user]

I understand, currently i'm on the process of writing a perl script, I'm able to get the details about the tickets. but in the json i'm getting those details aren't available. 

But however you just gave me an idea, how i can overcome this. Thank you :)

[Nir Haimov]

Happy i could help :)

If this is solved from you point of view, please mark my answer as the solution so this ticket will mark as closed.

Thanks :)