Difference between revisions of "mgh:gi-calendar"
From MGH Learn Pathology
| Line 5: | Line 5: | ||
,StaffFullName=description | ,StaffFullName=description | ||
,Date=Date | ,Date=Date | ||
| − | ;where=(TaskAbbrev='GI1' OR TaskAbbrev='GI2' OR TaskAbbrev='GI3' OR TaskAbbrev='GI4') AND NOT StaffAbbrev='OPEN';color=#d1d1d1;text color=#000000 | + | ;where=LocationAbbrev = ‘MGH’ AND (TaskAbbrev='GI1' OR TaskAbbrev='GI2' OR TaskAbbrev='GI3' OR TaskAbbrev='GI4') 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 | ||
Revision as of 08:46, August 5, 2024
1. Attending 2. Fellow 3. Resident
