How is the task_time_worked table linked to the incident table?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2018 08:09 PM
I am trying to understand how to access information from both the incident and task_time_worked tables. How are these linked?
When I create reports if I used the incident table, can I see the time worked for each incident?
When I create reports based on task_time_worked, can I access the parent incident?

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2018 08:16 PM
IF you open the table "task_time_worked", it has one reference field "Task" that refer to the Task table, this way it has get the incident number
The Task [task] table provides a time-tracking field called Time worked.

This field measures how long a record has been viewed in order to measure work time on a ticket. Any table that extends Task can use this field. To add the field, configure the form.
As the record is viewed, the timer counts upward. To pause the timer, click the stop icon ().
To resume the timer, click the start icon ().
When the task is saved, the amount of new time in the timer is used to generate a record on the Time Worked [task_time_worked] table. This table can be viewed as a related list on the task form.
By default, the time displayed in the Time worked field displays a cumulative value stored in the task record. If you modify a Time Worked record, the changes will not be reflected in the task timer.
You can set the property com.snc.time_worked.update_task_timer to enable updating of the task timer value based on changes to the time worked records. This is accomplished through the Update task timer business rule.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
07-30-2018 08:26 PM
i believe you can get the parent incident as well while creating a report on task_time_worked.
if it has an entry on "task_time_worked" table then it will appear in your report.