Derived Loop (for each) into a single html table?

smodarressiyazdi

In HR Talent, I developed a derived RichText field that utilizes a foreach loop to extract and display data for each direct report of a staff manager. The current behavior produces a separate table for every record (refer to the screenshots below). Although this functions correctly, the output would be more streamlined if all entries appeared within a single table containing a single header row. Has anyone successfully implemented something like this approach?

Final Output

For Each Loop on Employee BC

RichText Field on SupervisorChart BC for Individual Direct Report table

cleverly

Factor the opening and closing of the table into separate derived text variables, and leave GrievanceDirectReportList on SupervisorChart with just the HTML for one row.

Then you can do something like this:

Employee is a BusinessClass
    owned by hr

    Derived Fields

        GrievanceDirectReportList is a DerivedField
            type is RichText
            if (Employee.ActivePrimaryWorkAssignmentRel.AssignmentIsSupervisor >= 1)
                GrievanceDirectReportList = first EmployeeDirectReportList.GrievanceDirectReportHeader
                for each EmployeeDirectReportList
                    GrievanceDirectReportList += each.GrievanceDirectReportList
                GrievanceDirectReportList += last EmployeeDirectReportList.GrievanceDirectReportFooter
            else
                GrievanceDirectReportList = "<p>Employee is not a manager and does not have direct reports.</p>"
            return GrievanceDirectReportList