We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Trying to create a NOT EXISTS query in TCC for launching Transition Process

Question
21
Views
0
Comments
edited Aug 17, 2017 4:25AM in Taleo Enterprise Integrations

Summary

Trying to create a NOT EXISTS query in TCC for launching Transition Process

Content

HI All,

Can some one help me convert this SQL to a TCC script. I have tried a subquery which didn't work.

select * from Transition as t where not exists (select CandNumber from Transition as b where b.CandNumber = t.CandNumber and Process='Onboarding')

The Script should bring only the highlighted values.

CandNum     Process     Status
1111       PreHire         Completed 
1111       Onboarding Inprogress
2222       PreHire       Completed 
3333       PreHire Completed
 
The query i tried.
 
SubQuery

<quer:query projectedClass="TransitionProcess" alias="SQ" xmlns:quer="http://www.taleo.com/ws/integration/query"&gt;
  <quer:projections>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!