Difference between revisions of "learn:schedule-previousweek"
From MGH Learn Pathology
| Line 33: | Line 33: | ||
|join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id | |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id | ||
|fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort | |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort | ||
| − | |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleCallConference.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 1 }}' AND scheduleCallConference.DayNumber='1' AND NOT ResAbbrev='-' AND NOT TaskAbbrev | + | |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleCallConference.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 1 }}' AND scheduleCallConference.DayNumber='1' AND NOT ResAbbrev='-' AND NOT TaskAbbrev IN ('Call: Autopsy', 'Call: Junior CP', 'Call: BB/CP', 'HP Journal Club')|default={{:schtableempty}} |
|format=template|order by = sort ASC|template=schtableconfcallLeft}} | |format=template|order by = sort ASC|template=schtableconfcallLeft}} | ||
</td> | </td> | ||
Revision as of 07:40, July 6, 2020
|
Jan 06 Jan 06 |
Jan 07 Jan 07 |
Jan 08 Jan 08 |
Jan 09 Jan 09 |
Jan 10 Jan 10 |
Jan 11 |
Jan 12 |
|||||||||||||
|
|
|
|
|
|
|
