Difference between revisions of "Schedule"

@@ Line 64: / Line 64: @@
      |join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id
      |fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf
-     |where=YEAR(Date)='{{#timel: Y|now}}' AND  scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='0' AND scheduleCallConference.Type='Call' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT scheduleCallConference.TaskAbbrev='Call: Junior CP' AND NOT scheduleCallConference.TaskAbbrev='Call: Autopsy'|order by= scheduleCallConference.Sort DESC|default=
+     |where=YEAR(Date)='{{#timel: Y|now}}' AND  scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='7' AND scheduleCallConference.Type='Call' AND NOT scheduleCallConference.ResAbbrev='-' AND NOT scheduleCallConference.TaskAbbrev='Call: Junior CP' AND NOT scheduleCallConference.TaskAbbrev='Call: Autopsy'|order by= scheduleCallConference.Sort DESC|default=
      |format=template|template=schtableconf}}
 |