JDBC Driver for Greenhouse

Build 24.0.9062

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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9062