I'm working on a scheduling solution for managing shifts of hourly employees. In the solution, a manager is working in the context of a global table to view a calendar of the current schedule, and adding records in the shifts table. I'm using timestamp fields to define a relationship for a portal that shows more detailed info about all of the shifts within the defined range.
The problem is that I'd like to only show each worker once in that list, regardless of how many shifts they are working in the selected date range. I've tried multiple different methods of filtering the portal list, but