Business need is for a new panel/list on the LRCMyStaff page displaying ALL email addresses entered for a manager's staff. The result should mimic a SQL outer join between Employee and EmployeeContact.
1. An employee with no email would appear once with no data in the email field.
2. An employee with one email would appear once with data in the email field.
3. An employee with 2+ emails would appear multiple times, with one line for each email they have entered.
Created a one-to-many relation between Employee and EmployeeContact.
Created a list in the Employee BC referencing fields from the relation
The resulting list only renders one record per employee, so case 1 & 2 above are satisfied. However, employees with multiple email addresses only appear once.
What can we do to display all email addresses for case 3?
YNHHPersonalEmailRel
one-to-many relation to EmployeeContact
Field Mapping uses ByContactMethodActive
related.HROrganization = HROrganization
related.Employee = Employee
related.ContactMethod = 6
related.Active = true
YNHHEmployeePersonalEmail is a List
title is "PersonalEmail_-_Listing"
search field is PresentationNameSnapshot
use as filter
Display Fields
PresentationNameSnapshot
label is "Name"
sort order is ByPreferredName
Employee
label is "EmploymentID"
YNHHPersonalEmailRel.ContactDetail.EmailAddress
label is "Email"
YNHHPersonalEmailRel.IsWorkEmailorPhoneDer
label is "UseForWork"
Instance Selection
where (Active
and AncestorDirectSupervisor)
form is LRCFullResourceProfile
