Approvals
Query all of a job's approval flows.
SELECT
Note: Filters provided with one of the supported operators listed in the "Operators" column can be processed server-side, all the other filters are processed client-side.
SELECT * FROM Approvals WHERE Id = 45045175117;
SELECT * FROM Approvals WHERE JobId = 76125135117;
Columns
Name | Type | Operators | Description |
Id [KEY] | Int64 | = | The approval's unique identifier |
JobId | Int64 | = | The job for which the approval is configured. |
OfferId | Int64 | The specific offer for the approval. | |
Sequential | Bool | True or false based on whether the groups in the flow must approve sequentially. | |
Version | Int | The specific version of the flow. | |
ApprovalType | String | One of: open_job, offer_job, offer_candidate. | |
ApprovalStatus | String | One of: pending, approved, rejected. | |
RequestedByUserId | Int64 | The user who requested the approval be started. | |
ApproverGroups | String | Array of approver groups. |