Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Listing multiple hires in a single cell — Cloud Customer Connect
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

Listing multiple hires in a single cell

Accepted answer
39
Views
3
Comments
edited Sep 25, 2017 4:45PM in Reporting and Analytics Taleo Enterprise 3 comments

Content

I'm using the below formula to list all of the hires in a single cell, however when I try to clean up the output using either TRIM or REPLACE I receive a SQLExecDirectW error.  Is there a better way to incorporate the CASE logic?

(EVALUATE_AGGR('SYS.STRAGG(DISTINCT(%1||%2))' AS CHARACTER(1000),CASE "Submission Job Offer"."Status" WHEN 'Accepted' THEN "Candidate Identification"."First Name"||' '||"Candidate Identification"."Last Name" END,'<br>'))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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