Jobs
Query the jobs of the organization.
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 Jobs WHERE Id = 5831224147;
SELECT * FROM Jobs WHERE RequisitionId = '4551228237';
SELECT * FROM Jobs WHERE Status = 'open';
SELECT * FROM Jobs WHERE CreatedAt >= '2024-01-01 12:00:00.000' AND CreatedAt <= '2024-03-01 12:00:00.000';
SELECT * FROM Jobs WHERE UpdatedAt = '2024-01-01 12:00:00.000';
Columns
| Name | Type | Operators | Description |
| Id [KEY] | Int64 | = | Job ID. |
| Name | String | Name of the job. | |
| RequisitionId | String | = | An arbitrary ID provided by an external source. |
| Notes | String | Notes for the job. | |
| Confidential | Bool | If the job is confidential or not. | |
| Status | String | = | One of: open, closed, draft. |
| CreatedAt | Datetime | >=,>,<,<=,= | The timestamp when the job was created. |
| OpenedAt | Datetime | The timestamp when the job was opened. | |
| ClosedAt | Datetime | The timestamp when the job was closed. | |
| UpdatedAt | Datetime | >=,>,<,<=,= | The timestamp when the job was last updated. |
| IsTemplate | Bool | Indicates if the job is designed as a template to create other jobs. | |
| CopiedFromId | Int64 | The ID of the source job. | |
| DepartmentIds | String | Comma-delimited list of department IDs the job belongs to. | |
| Departments | String | Array of departments which the job belongs to. | |
| OfficeIds | String | Comma-delimited list of office IDs the job is associated with. | |
| Offices | String | Array of offices which the job is associated with. | |
| OpeningIds | String | Comma-delimited list of opening IDs associated with the job. | |
| Openings | String | Array of openings which the job is associated with. |