Difference between revisions of "learn:conferencecallvac"
From MGH Learn Pathology
| (4 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.TaskAbbrev | + | |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> | ||
Latest revision as of 13:57, August 4, 2026
