CasesTimelineActions
Tracks specific actions taken within a case timeline. This table captures operational workflows, resolution steps, and decision-making history for compliance and service monitoring.
Table Specific Information
Select
The Workday connector requires filtering on Cases_Id in order to perform the query.
For example:
SELECT * FROM CasesTimelineActions WHERE Cases_Id = '1234';
Workday Resource Information
Retrieves timeline items for a case. Comment timeline items include comments and associated attachments. Action timeline items include an action with an action text. Creation timeline items include a description, associated attachments, and a questionnaire answer if applicable.Secured by: REST API Public
Contains attachment(s)
Columns
| Name | Type | Description |
| Id [KEY] | String | The unique identifier (Id) for the case timeline action entry. This Id ensures that each recorded action within the case timeline is tracked independently. |
| CasesTimeline_Id [KEY] | String | The Workday Id of the case timeline that contains this action. This Id links the action to a specific timeline entry for proper sequencing of case events. |
| Cases_Id [KEY] | String | The Workday Id of the case that owns this timeline action. This Id ensures that the action is associated with the correct case record for reference and reporting. |
| Text | String | The text description of the action recorded in the case timeline. This field provides details on what action was taken or what update was made. |
| Desc_Prompt | Bool | If set to 'true', the query sorts the results in descending order. This setting ensures the most recent case timeline actions appear first. |
| Flag_Prompt | String | Retrieves cases with the assigned flag(s). |
| Label_Prompt | String | Retrieves cases with the assigned label(s). |
| MyCases_Prompt | Bool | Retrieves case timeline actions for cases owned by the processing user. This filter ensures that only relevant case activity is included in the results. |
| OpenCases_Prompt | Bool | Retrieves timeline actions for open cases and cases that were resolved or canceled within the last seven days. This filter helps users focus on active or recently closed case updates. |
| Sort_Prompt | String | Specifies the field used to sort query results. The default sorting field is creationDate, ensuring timeline actions are displayed in chronological order. |
| Status_Prompt | String | Retrieves cases with the specified status(es). |
| Substatus_Prompt | String | Retrieves cases with the specified substatus(es). |
| Team_Prompt | String | Retrieves cases with the specified service team(s). |