nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How to access worklog to access the time

unknown

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.

Accepted answers

Nir Haimov

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)

All comments

Nir Haimov

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)

unknown

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.

unknown

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 ?

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

cloud

jira-cloud

jql