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

Time tracking report based on filter query

Syed Mohamed Wahiduzzaman

I am using time tracking while creating my task where i can put estimated, remaining and logged hour, but when i am using filter i can't filter with these field, even filter don't show these field. how i can add these field in the filter option?

Wahid

Accepted answers

Fazila Ashraf

Hi @Syed Mohamed Wahiduzzaman

In the Advanced JQL, use 'originalEstimate' for estimates, 'remainingEstimate' for remaining and 'timespent' for logged work.

Piotr Bojko

You can use advanced searching with JQL - those fields will be available there. See Atlassian manual - https://confluence.atlassian.com/jiracore/blog/2015/07/search-jira-like-a-boss-with-jql.

You can use also Smart QL to power your jira even more with searching and reporting - https://marketplace.atlassian.com/apps/1218767/smart-ql-sql-jql-easy-reporting?hosting=server&tab=overview

All comments

Fazila Ashraf

Hi @Syed Mohamed Wahiduzzaman

In the Advanced JQL, use 'originalEstimate' for estimates, 'remainingEstimate' for remaining and 'timespent' for logged work.

Piotr Bojko

You can use advanced searching with JQL - those fields will be available there. See Atlassian manual - https://confluence.atlassian.com/jiracore/blog/2015/07/search-jira-like-a-boss-with-jql.

You can use also Smart QL to power your jira even more with searching and reporting - https://marketplace.atlassian.com/apps/1218767/smart-ql-sql-jql-easy-reporting?hosting=server&tab=overview

Syed Mohamed Wahiduzzaman

thanks

Syed Mohamed Wahiduzzaman

and how i get the date time for that log hour?

JiraYo

Those links are broken.. like search jira like a boss link.

I want to do the same thing. Agents are logging how much time is spent troubleshooting a thing. I have another field that logs the "thing" that they are spending time on.

I want to generate a report that sums up the total time spent 'timespent' on each "thing".

I will post back if i figure it out. I am completely new to reporting, seems you have to add these things called "series" and then it graphs it? but perhaps there is another way to do this. I simply want a list of which "things" agents are spending the most time on. Should be simple but its not a built in report.

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