Difference between revisions of "acc-vacations"

From MGH Learn Pathology
(Created page with "<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''VACATIONS'''||#000000|}}</center></td></tr></table> {{#cargo_query: tables=scheduleRESservice,res...")
 
Line 1: Line 1:
<table class='scheduletable'><tr><td bgcolor="#FFFFFF"><center>{{ColorText|'''VACATIONS'''||#000000|}}</center></td></tr></table>
 
 
{{#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
 
|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='VAC'|default={{:schtableempty}}|format=template|template=schtable}}
 
|where=scheduleRESservice.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='VAC'|default={{:schtableempty}}|format=template|template=schtable}}

Revision as of 17:35, September 25, 2019