Difference between revisions of "Residents Room"

@@ Line 184: / Line 184: @@
 |join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
 |fields=GROUP_CONCAT(scheduleRESservice.ResAbbrev),scheduleRESservice.Color,GROUP_CONCAT(residentMGH.full_name),residentMGH.pageid
-|group by=scheduleRESservice.Color
+|group by=scheduleRESservice.WeekNumber
 |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleRESservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'|default={{schtableempty|{{#explode:TaskAbbreviation|,|1}}}}|format=template|template=schtableres}}
 |}}