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. |