Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT status.updateTime, personName.givenName, personName.familyName 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')
- ORDER BY status.updateTime
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement