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; } } }

Capture Time spend value

Nazeer_rlr0cw

I created a story on 2020-07-10 and logged 18 hours on 07/10, 06 hours on 07/11 and 5 hours on 07/13.

I wrote a query like project = ABC and worklogdate <= 2020-07-12 and worklogdate >= 2020-07-18. I could see this story in the query result but in the column TIME SPENTI see the value as 29 hours (instead of 5 hours) and SIGMA TIME SPENT also showing the same 29 hours.

How can I get the correct TIME SPENT value for 07/13 alone.

Regards,

Nazeer.

Accepted answers

All comments

Gökçe Gürsel {Appfire}

Hi,

What is your hosting type?

Nic Brough -Adaptavist-

JQL is for finding issues, not reporting on them. Reporting is the job of the report that reads and displays the issues.

So, your query can be written in natural language as "Project = ABC and there has been time logged between these two dates".

The time spent on an issue is all of the logged work. That's it, it doesn't do anything else.

What you'll need to do is find an app that either

Can search for and report on work logs, rather than issues
Displays the work logs for a time period separately

Have a look in the marketplace, focussing on timesheet or time logging apps, some of them can do one or both of those.

Nazeer_rlr0cw

Thank you ... hosting type is Server

Nazeer_rlr0cw

Thank you Nic.

Gökçe Gürsel {Appfire}

Hi @Nazeer ,

I agree with the answer above, you need to find a plugin that fits those two criteria:

Can search for and report on work logs, rather than issues
Displays the work logs for a time period separately

Tempo is widely used, maybe it can help your case. I believe it has a calendar view feature that shows the logged time on a specific day.

Cheers,

Gökçe

Nazeer_rlr0cw

Thank you so much Gokce.

Mariana_Pryshliak_Saasjet_qysy8m

Hello @Nazeer

You can try Time between Statuses (server version).

This add-on calculates how long it takes an issue to move from one status to another. If I understand you correctly, this is actually what you need.

To set calculation you need to create status groups by choosing Start/Pause/Stop statuses through which issues have been moving in your workflow. So you can choose any start and stop statuses you want. These can be even the first and last statuses from the workflow.

You will get exactly those time spent data, which you have been searching for. You can also set up time limits with highlights.

If you have any additional questions, I'm here to help you:)

tbs startstop timers.png

Welcome!

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

Quick Links

Find more posts tagged with

jira