What's new in Customer Journeys?

Connect and learn more!
Filter not working for case statement — 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

Filter not working for case statement

Accepted answer


I am creating a HDL formatted report to produce a list of employees that require termination from HCM.

I have managed to produce a list of all the employees that match this requirement, but also I am picking up records that just need an assignment ending and not terminating.

I have tried filtering on the result produced but the data is still output in the report.

Content (please ensure you mask any confidential information):

Create a report that will pick up all active employees that have a specific user person type (in this case External Examiner) and count all of the assignments this employee has.


Howdy, Stranger!

Log In

To view full details, sign in.


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