Difference between revisions of "testserviceschedule"
From MGH Learn Pathology
| Line 160: | Line 160: | ||
,Date=Date | ,Date=Date | ||
;where=TaskAbbrev='BR1' OR TaskAbbrev='BR2';color=#FF7E46;text color=#000000 | ;where=TaskAbbrev='BR1' OR TaskAbbrev='BR2';color=#FF7E46;text color=#000000 | ||
| − | |tables=scheduleRFAview | + | |tables=scheduleRFAview,residentMGH |
| − | ;fields=CONCAT('🔸 Resident: ',ResAbbrev,' - ',TaskAbbrev)=name | + | ;join on=scheduleRFAview.ResAbbrev=residentMGH.copath_id |
| − | ,Date=Date | + | ;fields=CONCAT('🔸 Resident: ',scheduleRFAview.ResAbbrev,' - ',scheduleRFAview.TaskAbbrev)=name |
| − | ;where=(TaskAbbrev='BR1' OR TaskAbbrev='BR2') AND NOT ResAbbrev IN ('0', '-');color=#1730b0;text color=#FFFFFF | + | ,residentMGH.full_name=description |
| + | ,scheduleRFAview.Date=Date | ||
| + | ;where=(scheduleRFAview.TaskAbbrev='BR1' OR scheduleRFAview.TaskAbbrev='BR2') AND NOT scheduleRFAview.ResAbbrev IN ('0', '-');color=#1730b0;text color=#FFFFFF | ||
|tables=scheduleRFAview | |tables=scheduleRFAview | ||
;fields=CONCAT('🔹 Fellow: ',FellAbbrev,' - ',TaskAbbrev)=name | ;fields=CONCAT('🔹 Fellow: ',FellAbbrev,' - ',TaskAbbrev)=name | ||
Latest revision as of 07:37, October 12, 2019
Contents
Service Schedule (Current Week)
Autopsy
Error: Table scheduleRFAview not found.
Breast
Error: Table scheduleRFAview not found.
Bone & Soft Tissue
Error: Table scheduleRFAview not found.
Cardiovascular & Pulmonary
Error: Table scheduleRFAview not found.
Cytology
Error: Table scheduleRFAview not found.
Dermatopathology
Error: Table scheduleRFAview not found.
Head & Neck
Error: Table scheduleRFAview not found.
Gastrointestinal
Error: Table scheduleRFAview not found.
Genitourinary
Error: Table scheduleRFAview not found.
Gynecologic and Obstetric
Error: Table scheduleRFAview not found.
Hematopathology
Error: Table scheduleRFAview not found.
Neuropathology
Error: Table scheduleRFAview not found.
Renal
Error: Table scheduleRFAview not found.
