Difference between revisions of "learn:conferencecallvac"
From MGH Learn Pathology
| (9 intermediate revisions by the same user not shown) | |||
| Line 5: | Line 5: | ||
|join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id | |join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id | ||
|fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf | |fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf | ||
| − | |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} + 0 }}' AND scheduleCallConference. | + | |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} + 0 }}' AND scheduleCallConference.TaskAbbrev IN ('Call: Junior','Call: Senior','Call: BWH')|order by= scheduleCallConference.Sort ASC|default= |
| − | |format=template|template= | + | |format=template|template=scheduleResidentCall}} |
|7= | |7= | ||
{{#cargo_query: tables= scheduleCallConference,residentMGH | {{#cargo_query: tables= scheduleCallConference,residentMGH | ||
|join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id | |join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id | ||
|fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf | |fields= scheduleCallConference.ResAbbrev, scheduleCallConference.Color,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf | ||
| − | |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='7' AND scheduleCallConference. | + | |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='7' AND scheduleCallConference.TaskAbbrev IN ('Call: Junior','Call: Senior','Call: BWH') AND NOT scheduleCallConference.ResAbbrev='-'|order by= scheduleCallConference.Sort ASC|default= |
| − | |format=template|template= | + | |format=template|template=scheduleResidentCall}} |
| | | | ||
{{#cargo_query: tables= scheduleCallConference,residentMGH | {{#cargo_query: tables= scheduleCallConference,residentMGH | ||
|join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id | |join on= scheduleCallConference.ResAbbrev=residentMGH.copath_id | ||
| − | |fields= scheduleCallConference.ResAbbrev, scheduleCallConference. | + | |fields= scheduleCallConference.ResAbbrev, scheduleCallConference.TaskAbbrev,residentMGH.full_name, scheduleCallConference.TaskAbbrev=Conf |
| − | |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} + 0 }}' AND scheduleCallConference. | + | |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleCallConference.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleCallConference.DayNumber='{{#expr: {{#timel: N|{{Timezone}}}} + 0 }}' AND scheduleCallConference.TaskAbbrev IN ('Call: Junior','Call: Senior','Call: BWH')AND NOT scheduleCallConference.ResAbbrev='-'|order by= scheduleCallConference.Sort ASC|default= |
| − | |format=template|template= | + | |format=template|template=scheduleResidentCall}} |
}}</center> | }}</center> | ||
<br> | <br> | ||
| Line 25: | Line 25: | ||
{{#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. | + | |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.TaskAbbrev,residentMGH.full_name |
| − | |where=scheduleRESservice.TaskAbbrev='VAC' AND scheduleRESservice.Date > ' | + | |where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleRESservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='VAC' AND scheduleRESservice.Date > '2025-02-02'|group by=scheduleRESservice.WeekNumber,scheduleRESservice.ResAbbrev|default=<center>{{ColorText|''No scheduled vacations''|||3}}</center>|format=template|template=scheduleResident}} |
</td> | </td> | ||
Latest revision as of 13:57, August 4, 2026
