Difference between revisions of "learn:schedule-currentweek"
From MGH Learn Pathology
Line 140: | Line 140: | ||
|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=YEAR(Date)={{#time: Y|{{Timezone}}}} AND 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'|group by=scheduleRESservice.WeekNumber,scheduleRESservice.ResAbbrev|default={{:schtableempty}}|format=template|template=schtable}} |
</td> | </td> | ||
<td style="width: 10%"> | <td style="width: 10%"> |
Revision as of 15:58, July 30, 2020
Jan 13 Jan 13 |
Jan 14 Jan 14 |
Jan 15 Jan 15 |
Jan 16 Jan 16 |
Jan 17 Jan 17 |
Jan 18 |
Jan 19 |
|||||||||||||
|
|
|
|
|
|
|
|
|
Friday |
|
Jan 13Monday Jan 13 |
Jan 14Tuesday Jan 14 |
Jan 15Wednesday Jan 15 |
Jan 16Thursday Jan 16 |
Jan 17Friday Jan 17 |
Jan 18 |
Jan 19 |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|
|
|
|
|
|