Difference between revisions of "testpageEMI"
From MGH Learn Pathology
| Line 2: | Line 2: | ||
|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName),facultyMGH.pageid | |fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName),facultyMGH.pageid | ||
|group by=scheduleFACservice.Color | |group by=scheduleFACservice.Color | ||
| − | |where=LocationAbbrev = 'MGH' AND YEAR(Date)='2025' AND scheduleFACservice.TaskAbbrev='BST' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber=' | + | |where=LocationAbbrev = 'MGH' AND YEAR(Date)='2025' AND scheduleFACservice.TaskAbbrev='BST' AND scheduleFACservice.DayNumber='1' AND scheduleFACservice.WeekNumber='{{formatnum:{{#expr:{{#timel: W|now +3 week}}}}}}' |
|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResident}} | |default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResident}} | ||
|}} | |}} | ||
Revision as of 10:35, December 19, 2024
|}}
