Difference between revisions of "mgh:cardio-calendar"
From MGH Learn Pathology
| (2 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
{{:learn:schedule-monthlylegend}} | {{:learn:schedule-monthlylegend}} | ||
{{#cargo_compound_query: | {{#cargo_compound_query: | ||
| Line 6: | Line 5: | ||
,StaffFullName=description | ,StaffFullName=description | ||
,Date=Date | ,Date=Date | ||
| − | ;where= | + | ;where=LocationAbbrev='BWH' AND TaskAbbrev='MGB CV' AND NOT StaffAbbrev='OPEN';color=#d1d1d1;text color=#000000 |
|tables=scheduleRESservice,residentMGH | |tables=scheduleRESservice,residentMGH | ||
;join on= scheduleRESservice.ResAbbrev=residentMGH.copath_id | ;join on= scheduleRESservice.ResAbbrev=residentMGH.copath_id | ||
| Line 12: | Line 11: | ||
,full_name=description | ,full_name=description | ||
,Date=Date | ,Date=Date | ||
| − | ;where=(TaskAbbrev='CV' OR TaskAbbrev=' | + | ;where=LocationAbbrev='BWH' AND (TaskAbbrev='MGB CV' OR TaskAbbrev='MGB CV (E)') AND NOT ResAbbrev IN ('0', '-', 'TBD') AND NOT UID LIKE '%BWH%';color=#1730b0;text color=#FFFFFF |
|tables=scheduleFELLservice,residentMGH | |tables=scheduleFELLservice,residentMGH | ||
;join on= scheduleFELLservice.FellAbbrev=residentMGH.copath_id | ;join on= scheduleFELLservice.FellAbbrev=residentMGH.copath_id | ||
| Line 18: | Line 17: | ||
,full_name=description | ,full_name=description | ||
,Date=Date | ,Date=Date | ||
| − | ;where=TaskAbbrev | + | ;where=TaskAbbrev='MGB CV' AND NOT FellAbbrev IN ('0', '-', 'TBD');color=#000000;text color=#FFFFFF |
| − | |tables=scheduleCallConference, facultyMGH;join on=scheduleCallConference.ResAbbrev = facultyMGH._pageName;fields=CONCAT('一',scheduleCallConference.Hour,' ',scheduleCallConference.TaskAbbrev,': ',scheduleCallConference.Notes,' - ', scheduleCallConference.ResAbbrev)=name,facultyMGH.fullname=description,scheduleCallConference.Date=Date;where=TaskAbbrev='Outs' AND NOT ResAbbrev='-';color=#fff673;text color=black;where=scheduleCallConference.Notes='CV | + | |tables=scheduleCallConference, facultyMGH;join on=scheduleCallConference.ResAbbrev = facultyMGH._pageName;fields=CONCAT('一',scheduleCallConference.Hour,' ',scheduleCallConference.TaskAbbrev,': ',scheduleCallConference.Notes,' - ', scheduleCallConference.ResAbbrev)=name,facultyMGH.fullname=description,scheduleCallConference.Date=Date;where=TaskAbbrev='Outs' AND NOT ResAbbrev='-';color=#fff673;text color=black;where=scheduleCallConference.Notes='MGB CV' |
|format=calendar|}} | |format=calendar|}} | ||
Latest revision as of 13:53, March 5, 2026
1. Attending 2. Fellow 3. Resident
