JobOpenings
Query job openings.
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 JobOpenings WHERE Id = 4221228237;
SELECT * FROM JobOpenings WHERE JobId = 5831224147;
SELECT * FROM JobOpenings WHERE JobId = 5831224147 AND Id = 4221228237;
SELECT * FROM JobOpenings WHERE Status = 'closed';
Columns
| Name | Type | Operators | Description |
| Id [KEY] | Int64 | = | Opening ID. |
| JobId | Int64 | = | ID of the job that is associated with the opening. |
| OpeningId | String | Text string used to identify the opening. | |
| Status | String | = | Either 'open' or 'closed.' |
| OpenedAt | Datetime | The timestamp when the opening was created. | |
| ClosedAt | Datetime | The timestamp when the opening was closed. | |
| ApplicationId | Int64 | The application that was used to fill the opening. | |
| CloseReasonId | String | The ID of the close reason. | |
| CloseReasonName | String | The name of the close reason. |