Timetracker, how to use the fields as a filter columns to make a dashboard or use REST API?

[Cole]

I was wondering how I could use the "Worklog Author", "Total Logged", and "Date Started" fields that are shown in timetracker reporting in the normal JIRA filter search columns.

I am wanting to make a static dashboard that shows all employees time spent over the past 30 days. Instead of having to go in to the reporting area every single time and change the dates manually.

All I need to see is the "user" and "total logged" for the last 30 days. Is there another way to do this and just have a static page for managers to go to and see all employees?

Could REST API be used to do this?

[Attila Bordás _Everit_]

Hello there,

Unfortunately, Timetracker does not provide any additional JQL function to get these fields yet.

I suggest you to use the JIRA REST API or our Worklog Query Plugin to gather your required worklog data and develop your dashboard gadget or some kind of application to display the data.

To be clear, "author", "timeSpent", "started", etc. are all default JIRA fields, what you can use with REST API. 

You can get a JSON response like this for example:

"...
"started": "2017-02-06T16:03:48.097+0000",

"timeSpent": "3h 20m",

"timeSpentSeconds": 12000,

"id": "100028",

"issueId": "10002"

..." 

[Cole]

If I get the Worklog Query Program would I be able to make a page that displays data that looks exactly like the User Quick Summary on Timetracker reporting? If so, how?

Do I need to have Timetracker to use Restful Worklog Query or can I just use the ladder?

Every time I go to reporting on Timetracker the page takes an extremely long time to load, so it doesn't seem viable for me, plus I would like just a static page for the last 30 days.   

[Attila Bordás _Everit_]

You don't need the Timetracker to use our Worklog Query plugin.

I cannot describe to you exactly how to build your application, but yes, you can develop something that will show you exactly the same data. You just need to retrieve the work log data using Worklog Query plugin or the default JIRA REST API. Basically, you need to query for the users you want ("author" or "worklogAuthor"), in an interval with 30 days using the "started" field and the current date and summarize the "timeSpent" value for each user. Use the documentations what I already posted in my previous answer.

You can do this as a simple web app, Excel app, Google app, etc. or you can even make a JIRA gadget. (here is the documentation to how).

In the future, we want to add some gadgets like this to Timetracker, but I can't tell you the exact date.

[Cole]

I just don't see much documentation on how to make specific queries to pull certain things.

[Attila Bordás _Everit_]

I'm sorry if I was not clear. You cannot exactly query the summarized data. You need to develop some logic to query, select and summarize logged times for users, etc. I can't give you an out-of-the-box solution for your problem, but maybe you can find some customizable dashboard gadget add-on on the Marketplace.

[Cole]

Can you tell me why the reporting is so slow with the Timetracker plugin? It takes so long that Chrome thinks it is non-responsive and wants to kill the page. This is anytime I load it, change the date range, or filter.

[Attila Bordás _Everit_]

I'm sorry to hear that. But the good news is, that we are currently working to improve the performance of the Reporting. Thank you for your patience!

[Cole]

So this is normal and not just me?

[Attila Bordás _Everit_]

Definitely not normal. Please contact me at feedback.jttp@everit.biz to discuss your performance issue!

[Attila Bordás _Everit_]

We just released the new Timetracker version with bug fixes and some changes that can improve the performance. Please update, try it out and I hope that you will experience a performance improvement on the Reporting page.