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
CASE WHEN Help — 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

CASE WHEN Help

Received Response
16
Views
4
Comments
edited Aug 2, 2021 7:40PM in Taleo Enterprise 4 comments

Content

Hello, 

I need some assistance with a CASE WHEN statement. 

I have an offer report where I would like to add in the Comments added to the candidate submission by specific users. The offers may not always have comments to add but when they do I want them to pull in this report. I attempted to add a filter to accomplish this but unfortunately, these filters caused the report to only showed offers where there were comments added.

 

I attempted a CASE WHEN statement but I keep getting an error. Below is the statement: 

 

CASE WHEN "Submission Tracking History"."Transaction Event Name" IN (‘Comments Added’) THEN "Submission Tracking History"."Transaction Comments" 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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