JobPosts
Query the job posts 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 JobPosts WHERE Id = 4221228237;
SELECT * FROM JobPosts WHERE JobId = 5831224147;
SELECT * FROM JobPosts WHERE Internal = TRUE;
SELECT * FROM JobPosts WHERE Active = FALSE;
SELECT * FROM JobPosts WHERE Live = TRUE;
SELECT * FROM JobPosts WHERE CreatedAt >= '2024-01-01 12:00:00.000' AND CreatedAt <= '2024-03-01 12:00:00.000';
SELECT * FROM JobPosts WHERE UpdatedAt = '2024-01-01 12:00:00.000';
Columns
| Name | Type | Operators | Description |
| Id [KEY] | Int64 | = | Job post ID. |
| Title | String | Title of the job post. | |
| LocationId | Int64 | The ID of the location of the job. | |
| LocationName | String | The name of the location of the job. | |
| Internal | Bool | = | If true, the job post has been posted (or is to be posted) on an internal job board. |
| External | Bool | If true, the job post has been posted (or is to be posted) on an external job board. | |
| Active | Bool | = | If false, the job post has been deleted. |
| Live | Bool | = | If true, the job post status is set to live. |
| FirstPublishedAt | Datetime | The timestamp when the job post was first set to live. | |
| JobId | Int64 | = | The ID of the job that the job post is for |
| Content | String | The text of the job post as posted to the external job board. | |
| InternalContent | String | The text of the job post if posted to the internal job board, if different than the external job board. | |
| UpdatedAt | Datetime | >=,>,=,<,<= | The timestamp when the job post was last updated. |
| CreatedAt | Datetime | >=,>,=,<,<= | The timestamp when the job post was created. |
| DemographicQuestionSetId | Int64 | The demographic question set associated with the job post. | |
| Questions | String | An array of questions associated with the job post. |