Difference between revisions of "ServiceSchedule"
From MGH Learn Pathology
| Line 47: | Line 47: | ||
{{#cargo_query: tables=scheduleRESservice,residentMGH | {{#cargo_query: tables=scheduleRESservice,residentMGH | ||
|join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id | |join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id | ||
| − | |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name | + | |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name,residentMGH.pageid |
|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleRESservice.TaskAbbrev='TaskAbbreviation'|default={{:schtableempty}}|format=template|template=schtableres}} | |where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleRESservice.TaskAbbrev='TaskAbbreviation'|default={{:schtableempty}}|format=template|template=schtableres}} | ||
|}} | |}} | ||
| Line 61: | Line 61: | ||
{{#cargo_query: tables=scheduleFELLservice,residentMGH | {{#cargo_query: tables=scheduleFELLservice,residentMGH | ||
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id | |join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id | ||
| − | |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color,residentMGH.full_name | + | |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.Color,residentMGH.full_name,residentMGH.pageid |
|where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleFELLservice.TaskAbbrev='TaskAbbreviation' |format=template|template=schtableres}} | |where=scheduleFELLservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleFELLservice.TaskAbbrev='TaskAbbreviation' |format=template|template=schtableres}} | ||
|}} | |}} | ||
