Skip to content

Instantly share code, notes, and snippets.

@ahl

ahl/all_active.sql

Created April 12, 2019 04:55
Show Gist options
  • Save ahl/3195700ad377dc24bbcfd79693cb67a9 to your computer and use it in GitHub Desktop.
Save ahl/3195700ad377dc24bbcfd79693cb67a9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
all_active.sql
SELECT * FROM google_hire.list_applications AS app
JOIN google_hire.list_candidates AS can
ON app.candidate = can.name
WHERE app.tenant = 'my_tenant'
AND app.filter='status.state=ACTIVE'
AND can.tenant = 'my_tenant'
AND can.filter='applications.status.state=ACTIVE’
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment