Difference between revisions of "learn:conferencecallvac"
From MGH Learn Pathology
| Line 16: | Line 16: | ||
{{#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.TaskAbbrev IN ('Call: Junior','Call: Senior','Call: BWH')AND NOT scheduleCallConference.ResAbbrev='-'|order by= scheduleCallConference.Sort ASC|default= | |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=scheduleResident}} | |format=template|template=scheduleResident}} | ||
