a guest Apr 22nd, 2019 65 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT * FROM google_hire.list_applications AS app
  2.  JOIN google_hire.list_candidates AS can
  3.  ON app.candidate =
  4.  WHERE app.tenant = 'my_tenant'
  5.  AND app.filter='status.state=ACTIVE'
  6.  AND can.tenant = 'my_tenant'
  7.  AND can.filter='applications.status.state=ACTIVE'
  8.  AND job = (SELECT name FROM google_hire.list_jobs
  9.    WHERE tenant='my_tenant'
  10.    AND filter='state=OPEN'
  11.    AND title='Software Engineer')
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand