Difference between revisions of "testpageEMI"

From MGH Learn Pathology
Line 1: Line 1:
{{nextweekvar|+2}}
+
{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id
 
+
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName),facultyMGH.pageid
 
+
|group by=scheduleFACservice.Color
{{#var:MondayNW}}-{{#timel: W|now +2 week}}-
+
|where=LocationAbbrev = 'MGH' AND YEAR(Date)='2025' AND scheduleFACservice.TaskAbbrev='BR1' AND scheduleFACservice.DayNumber='5' AND scheduleFACservice.WeekNumber='{{formatnum:{{#expr:{{#timel: W|now +2 week}}}}}}'
 
+
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResident}}
 
+
|}}
 
 
{{#cargo_query: tables=scheduleFACservice |fields=scheduleFACservice.Date |where=YEAR(Date)='{{#var:MondayNW}}' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{formatnum:{{#expr:{{#timel: W|now +2 week}}}}}}' AND scheduleFACservice.TaskAbbrev='BR1' |limit=1|more results text=}}
 

Revision as of 10:26, December 19, 2024

MJL

|}}