Offers
Query the offers 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 Offers WHERE Id = 2230325147;
SELECT * FROM Offers WHERE ApplicationId = 2450155147;
SELECT * FROM Offers WHERE Status = 'accepted';
SELECT * FROM Offers WHERE CreatedAt >= '2024-01-01 12:00:00.000' AND CreatedAt <= '2024-03-01 12:00:00.000';
SELECT * FROM Offers WHERE UpdatedAt = '2024-01-01 12:00:00.000';
SELECT * FROM Offers WHERE ResolvedAt <= '2024-01-01 12:00:00.000';
SELECT * FROM Offers WHERE SentAt >= '2024-01-01 12:00:00.000';
SELECT * FROM Offers WHERE StartsAt = '2024-01-01 12:00:00.000';
Columns
Name | Type | Operators | Description |
Id [KEY] | Int64 | = | Offer ID. |
Version | Int | The version number of this offer. | |
ApplicationId | Int64 | = | Application ID. |
JobId | Int64 | Job ID. | |
CandidateId | Int64 | Candidate ID. | |
CreatedAt | Datetime | >=,>,<,<=,= | The timestamp when the offer was created. |
UpdatedAt | Datetime | >=,>,<,<=,= | The timestamp when the offer was updated. |
ResolvedAt | Datetime | >=,>,<,<=,= | The timestamp when this offer was resolved. |
SentAt | Date | >=,>,<,<=,= | The date when this offer was sent to the candidate. |
StartsAt | Date | >=,>,<,<=,= | The date when the candidate starts. |
Status | String | = | One of: unresolved, accepted, rejected, deprecated. |