a guest Apr 22nd, 2019 65 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
- 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'
- AND job = (SELECT name FROM google_hire.list_jobs
- WHERE tenant='my_tenant'
- AND filter='state=OPEN'
- AND title='Software Engineer')
RAW Paste Data