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
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

TCC Union script?

edited Dec 13, 2022 6:44AM in Taleo Enterprise

Summary

Does anyone have a sample TCC script with a union?

Content

I'm looking for a TCC script that performs a union on data from the User entity.    Here's what I'm trying to do:
  1. String value ''Line Manager"
  2. projection: first name
  3. projection: last name
  4. projection: employee ID

UNION

  1. String value ''Dsg Manager"
  2. projection: first name
  3. projection: last name
  4. projection: employee code

where employee status=active

 

The xml I found in the TCC user guide hasn't helped much.  I've tried adding xml as both a Complex Projection and a Subquery (Advanced Tab) but I keep getting 'Source is Not Valid' errors.  Can anyone tell what I'm doing wrong?  Can anyone tell me what's wrong with the xml below (added as a subquery)

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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