glints
.public
Tables
(current)
Columns
Constraints
Relationships
Orphan Tables
Anomalies
Routines
count_job_applications_goodfit(job_id uuid)
Description
Returns the number of job applications marked as “good fit”
Parameters
Name
Type
Mode
job_id
uuid
IN
Definition
BEGIN RETURN ( SELECT count(id) AS "goodFitCounts" FROM "Applications" WHERE "JobId" = job_id AND "status" IN ('IN_REVIEW', 'INTERVIEWING', 'OFFERED', 'HIRED') ); END