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
Summary
Multiple emails/phones with multiple recordsContent
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
0