Difference between revisions of "mgh:gi-calendar"

Revision as of 04:35, August 28, 2021

1. Attending 2. Fellow 3. Resident

@@ Line 2: / Line 2: @@
 {{#cargo_compound_query:
 |tables=scheduleFACservice
-;fields=CONCAT({{#switch:TaskAbbrev|GI1=E2|}},' ATT: ',StaffAbbrev)=name
+;fields=CONCAT(TaskAbbrev,' A: ',StaffAbbrev,' F: ',FellAbbrev,' R: ',ResAbbrev)=name
 ,StaffFullName=description
 ,Date=Date
-;where=(TaskAbbrev='GI1' OR TaskAbbrev='GI2' OR TaskAbbrev='GI3' OR TaskAbbrev='GI4') AND NOT StaffAbbrev='OPEN';color=#d1d1d1;text color=#000000
+;where=TaskAbbrev='GI1' AND NOT StaffAbbrev='OPEN';color=#d1d1d1;text color=#000000
-|tables=scheduleRESservice,residentMGH
-;join on= scheduleRESservice.ResAbbrev=residentMGH.copath_id
-;fields=CONCAT(TaskAbbrev,' RES: ',ResAbbrev)=name
-,full_name=description
-,Date=Date
-;where=(TaskAbbrev='GI1' OR TaskAbbrev='GI2' OR TaskAbbrev='GI3' OR TaskAbbrev='GI4') AND NOT ResAbbrev IN ('0', '-', 'TBD');color=#1730b0;text color=#FFFFFF
-|tables=scheduleFELLservice,residentMGH
-;join on= scheduleFELLservice.FellAbbrev=residentMGH.copath_id
-;fields=CONCAT(TaskAbbrev,' FELL: ',FellAbbrev)=name
-,full_name=description
-,Date=Date
-;where=TaskAbbrev IN ('GI1', 'GI2', 'GI3', 'GI4') 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='GI'
 |format=calendar|}}