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 Dec 13, 2022 7:07AM in 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!