Difference between revisions of "scheduleNow"

From MGH Learn Pathology
Line 13: Line 13:
 
{{:scheduleDictionaryAPempty}}
 
{{:scheduleDictionaryAPempty}}
 
|{{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation|
 
|{{#arraymap:{{scheduleDictionaryAPresident}}|;|TaskAbbreviation|
{{#cargo_query: tables=scheduleRESservice,residentMGH
+
{{#cargo_query: tables=scheduleRESservice_view
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
 
 
|fields=
 
|fields=
GROUP_CONCAT(DISTINCT scheduleRESservice.ResAbbrev),
+
ResAbbrev,
scheduleRESservice.TaskAbbrev,
+
TaskAbbrev,
GROUP_CONCAT(DISTINCT residentMGH.full_name),
+
FullName,
scheduleRESservice.TaskTags,
+
Pager
pageid
 
 
|group by=scheduleRESservice.WeekNumber
 
|group by=scheduleRESservice.WeekNumber
|where=LocationAbbrev='MGH' AND YEAR(Date)={{#timel: Y|{{Timezone}}}} AND scheduleRESservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentNew}}
+
|where=LocationAbbrev='MGH' AND Year={{#timel: Y|{{Timezone}}}} AND WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentNew}}
 
|}}
 
|}}
 
}}
 
}}

Revision as of 14:08, July 30, 2024