|
|
Line 61: |
Line 61: |
| |join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id | | |join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id |
| |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name | | |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name |
− | |where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleRESservice.TaskAbbrev='VAC'|default={{:schtableempty}}|format=template|template=schtable}} | + | |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleRESservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleRESservice.TaskAbbrev='VAC'|default={{:schtableempty}}|format=template|template=schtable}} |
| </td> | | </td> |
| <td style="width: 10%"> | | <td style="width: 10%"> |