WORKGROUP TIME-TRACKING
Disclosed are systems, methods, and computer readable media for creating, and using time tracking data objects which can be used for applications such as tracking efforts expended by a group of users on tasks to which they have been assigned. In one embodiment, when a record is saved, it is determined if an attribute of the record has changed. Examples of attributes of a record may be the owner of a record, the status of a record, a case number, the group member's name, or the workgroup a member to whom the record belongs. When an attribute of the record has changed and the record has an open status, a time tracking data object is created. The time tracking data object may contain multiple fields storing information regarding attributes of the record. The fields may store information such as a start time, duration time, and status of the time tracking data object.
1 . A method comprising:
determining that an attribute of a record in a database has changed;
determining whether the record has an open status or a closed status;
when the record has the open status, determining whether an owner of the record is a member of a designated workgroup; and
when the owner is a member of the designated workgroup, creating a time tracking data object associated with the record, the time tracking data object including a plurality of fields storing information indicating one or more attributes of the record, the fields including a start time field indicating a start time of the time tracking data object, a duration field indicating a duration of the time tracking data object, and a status field indicating a status of the time tracking data object.
2 . The method of claim 1 , the changed attribute being an indication of the owner of the record.
3 . The method of claim 1 , the changed attribute being an indication of a status of the record.
4 . The method of claim 3 , the changed attribute being an indication that the record does not have the closed status.
5 . The method of claim 1 , the determining that the attribute of the record has changed being performed responsive to saving the record to the database.
6 . The method of claim 1 , the one or more attributes being selected from the group consisting of: a case number, a case ID, a member name, a member ID, a member's workgroup, a type of owner, and an initial workgroup assignment.
7 . The method of claim 1 , the record being a case.
8 . The method of claim 7 , one or more further time tracking data objects being associated with the case, the one or more further time tracking data objects each including a plurality of fields storing information indicating a creation time, a transfer time, and status of the case.
9 . The method of claim 8 , the status having an open status, a closed status, an on-hold status, or an active status.
10 . The method of claim 1 , further comprising:
determining whether one or more further time tracking data objects associated with the record have an open status; and
when the one or more further time tracking data objects have the open status, updating a status field of the one or more further time tracking data objects to indicate a closed status.
11 . The method of claim 1 , further comprising:
receiving a message indicating that the owner of the record is a member of the designated workgroup.
12 . The method of claim 1 , further comprising:
receiving a message indicating that the owner of the record is not a member of the designated workgroup.
13 . The method of claim 12 , further comprising:
responsive to receiving the message; determining whether one or more time tracking data objects associated with the record have an open status; and
when the one or more time tracking data objects have the open status, updating a status field of the one or more further time tracking data objects to indicate a closed status.
14 . The method of claim 1 , further comprising:
receiving a message indicating that the record has been deleted;
responsive to receiving the message; determining whether one or more time tracking data objects are associated with the record; and
when one or more time tracking data objects are associated with the record, updating one or more of the fields storing information indicating attributes of the record.
15 . The method of claim 14 , the updated one or more fields including the status field indicating that the record has a deleted status.
16 . The method of claim 14 , the updated one or more fields including an ID field identifying the record.
17 . A system comprising:
a database system;
one or more servers configured to:
determine that an attribute of a record in the database system has changed;
determine whether the record has an open status or a closed status;
when the record has the open status, determine whether an owner of the record is a member of a designated workgroup; and
when the owner is a member of the designated workgroup, create a time tracking data object associated with the record, the time tracking data object including a plurality of fields storing information indicating attributes of the record, the fields including a start time field indicating a start time of the time tracking data object, a duration field indicating a duration of the time tracking data object, and a status field indicating a status of the time tracking data object.
18 . The system of claim 17 , further comprising:
determining whether one or more further time tracking data objects associated with the record have an open status; and
when the one or more further time tracking data objects have the open status, updating a status field of the one or more further time tracking data objects to indicate a closed status.
19 . The system of claim 17 , further comprising:
receiving a message indicating that the owner of the record is a member of the designated workgroup.
20 . The system of claim 17 , further comprising:
receiving a message indicating that the owner of the record is not a member of the designated workgroup.
21 . The system of claim 17 , further comprising:
receiving a message indicating that the record has been deleted;
responsive to receiving the message; determining whether one or more time tracking data objects are associated with the record; and
when one or more time tracking data objects are associated with the record, updating one or more of the fields storing information indicating attributes of the record.
22 . The system of claim 17 , the record being a case and one or more further time tracking data objects being associated with the case, the one or more further time tracking data objects each including a plurality of fields storing information indicating a creation time, a transfer time, and status of the case.
23 . The system of claim 17 , the record referring to at least one second record such that the time tracking data object includes a plurality of fields storing information indicating attributes of the record and the at least one second record.
24 . The system of claim 17 , the database system being a component of a multi-tenant database in an on-demand service environment.
25 . One or more computer readable media having instructions stored thereon for performing a method, the method comprising:
determining that an attribute of a record in a database has changed;
determining whether the record has an open status or a closed status;
when the record has the open status, determining whether an owner of the record is a member of a designated workgroup; and
when the owner is a member of the designated workgroup, creating a time tracking data object associated with the record, the time tracking data object including a plurality of fields storing information indicating attributes of the record, the fields including a start time field indicating a start time of the time tracking data object, a duration field indicating a duration of the time tracking data object, and a status field indicating a status of the time tracking data object.
26 . The one or more computer readable media of claim 25 , the instructions further comprising:
determining whether one or more further time tracking data objects associated with the record have an open status; and
when the one or more further time tracking data objects have the open status, updating a status field of the one or more further time tracking data objects to indicate a closed status.
27 . The one or more computer readable media of claim 25 , the instructions further comprising:
receiving a message indicating that the owner of the record is a member of the designated workgroup.
28 . The one or more computer readable media of claim 25 , the instructions further comprising:
receiving a message indicating that the owner of the record is not a member of the designated workgroup.
29 . The one or more computer readable media of claim 25 , the instructions further comprising:
receiving a message indicating that the record has been deleted;
responsive to receiving the message; determining whether one or more time tracking data objects are associated with the record; and
when one or more time tracking data objects are associated with the record, updating one or more of the fields storing information indicating attributes of the record.
30 . The one or more computer readable media of claim 25 , the record being a case and one or more further time tracking data objects being associated with the case, the one or more further time tracking data objects each including a plurality of fields storing information indicating a creation time, a transfer time, and status of the case.