Difference between revisions of "learn:schedule-currentweek"

@@ Line 78: / Line 78: @@
 scheduleCallConference.Sort
      |where=YEAR(Date)='{{#var:Friday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='5' AND NOT ResAbbrev='-' AND NOT TaskAbbrev='Outs'|default={{:schtableempty}}
+    |format=template|order by = Sort ASC|template=schtableconfcallLeft}}
+{{#cargo_query: tables=scheduleCallConference,facultyMGH
+    |join on=scheduleCallConference.ResAbbrev=facultyMGH.copath_id
+    |fields=
+scheduleCallConference.ResAbbrev,
+scheduleCallConference.Color,
+residentMGH.full_name,
+scheduleCallConference.TaskAbbrev,
+scheduleCallConference.Sort
+    |where=YEAR(Date)='{{#var:Friday}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='5' AND NOT ResAbbrev='-' AND TaskAbbrev='Outs'|default={{:schtableempty}}
      |format=template|order by = Sort ASC|template=schtableconfcallLeft}}
 </td>