TaskApprovalRequests
Retrieve task approval requests.
View-Specific Information
Select
The add-in uses the SAP Ariba API to process WHERE clause conditions built with the following columns and operators. The add-in processes other filters client-side within the add-in.
- ProjectId supports the '=' comparison operator.
SELECT * FROM TaskApprovalRequests WHERE ProjectId = 'WS12345'
Columns
Name | Type | References | Description |
TaskId [KEY] | String |
Tasks.InternalId | Specifies the internal ID of the task. Example: TSK13758. |
ApprovalReqId [KEY] | String | Specifies the user ID of the approval requester. Example: useraaa. | |
Dependencies | String | Specifies the internal ID of the task that was chosen as a predecessor while creating a todo task. | |
Reason | String | Specifies if a task action is required or optional. Optional tasks can be canceled to dismiss them with no further action. Example: Action is Required. | |
Status | String | Specifies the status of the task. When approver performs approval, the possible values are: Approved, Rejected, Denied, Ready for approval, Pending for approval. | |
ApprovalRequired | Bool | Indicates whether approval is required. | |
UserApprovers | String | Lists users, who are approvers specified during the creation of approval task. | |
ApproverUsers | String | Lists all the active approver users expanded from groups in the approval flow. | |
ApproverGroups | String | Lists all groups. | |
ReadOnly | Bool | Indicates read-only task. | |
Dependency | String | Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. | |
DependencyDependencies | String | Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Specifies the internal ID of the task that was chosen as a predecessor while creating a todo task. | |
DependencyApprovalReqId | String | Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Specifies the user ID of the approval requester. Example: useraaa. | |
DependencyReason | String | Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Specifies if a task action is required or optional. Optional tasks can be canceled to dismiss them with no further action. Example: Action is Required. | |
DependencyStatus | String | Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Specifies the status of the task. When approver performs approval, the possible values are: Approved, Rejected, Denied, Ready for approval, Pending for approval. | |
DependencyApprovalRequired | Bool | Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Indicates whether approval is required. | |
DependencyUserApprovers | String | Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Lists users, who are approvers specified during the creation of approval task. | |
DependencyApproverUsers | String | Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Lists all the active approver users expanded from groups in the approval flow. | |
DependencyApproverGroups | String | Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Lists all groups. | |
DependencyReadOnly | Bool | Specifies the internal ID of the predecessor phase for the task. Example: AAP8AGSUT9UgV. Indicates read-only task. | |
ProjectId [KEY] | String |
Projects.InternalId | Specify the unique identifier of the sourcing project for which you want to fetch task details. Example, Try it out with: WS17371155. |