Difference between revisions of "learn:oncallAMP"

Revision as of 12:12, September 9, 2021

SGS

@@ Line 1: / Line 1: @@
-{{#cargo_query: table=scheduleFACservice,facultyMGH|join on=scheduleFACservice.StaffAbbrev=facultyMGH.copath_id
+{{#cargo_query: table=scheduleFACservice|fields=scheduleFACservice.StaffAbbrev|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.DayNumber='{{#time:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}' AND scheduleFACservice.DayNumber='7' AND TaskAbbrev = 'GI1'|format=template|template=text|no html}}
-|fields=GROUP_CONCAT(scheduleFACservice.StaffAbbrev),scheduleFACservice.TaskAbbrev,GROUP_CONCAT(scheduleFACservice.StaffFullName),facultyMGH.pageid
-|group by=scheduleFACservice.Color
-|where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleFACservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleFACservice.DayNumber='{{#time:N|now}}' AND scheduleFACservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0}}' AND scheduleFACservice.DayNumber='7' AND TaskAbbrev = 'GI1'
-|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleFaculty}}