Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
CASE WHEN Help
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"
0