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

[Piotr Bojko · Accepted solution]

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

[Fazila Ashraf · Accepted solution]

Hi @Syed Mohamed Wahiduzzaman

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

[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.