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
Get Started with Redwood for Oracle Cloud HCM   Begin Now

Display multiple emails/phones on one row when there ae multiple records of the same type

edited Apr 15, 2021 3:26PM in Reporting and Analytics for HCM 2 comments

Summary

Multiple emails/phones with multiple records

Content

Hi All,

I have built my query for displaying employee information with their different emails and different phone numbers. I created a Logical SQL that does several left joins to get the records into one row (this part is working well)

I have found several employees that could have 2 emails for Company Email or 2 work phones

Example

Work Email: Fred.Flinstone@bedrock.com

Company Email: FreddyFlint@bedrock.com

Company Email: FFlintsone@hotmail.com

Currently I have a rank on my phones and emails to return the first instance but I would like to let the users know that there is another email that might need to be verified

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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