Difference between revisions of "mgh:gyn-calendar"

Revision as of 08:42, July 1, 2020

GYL, GYS, & OB

@@ Line 2: / Line 2: @@
 {{#cargo_compound_query:
 |tables=scheduleFACservice
-;fields=CONCAT('🔘 ',TaskAbbrev,' - ',StaffLName,' (',StaffAbbrev,')')=name
+;fields=CONCAT(TaskAbbrev,' ATT: ',StaffAbbrev)=name
 ,StaffFullName=description
 ,Date=Date
-;where=TaskAbbrev='GYL' OR TaskAbbrev='GYS' OR TaskAbbrev='OB';color=#d1d1d1;text color=black
+;where=TaskAbbrev='GYL' OR TaskAbbrev='GYS' OR TaskAbbrev='OB' AND NOT StaffAbbrev='OPEN';color=#d1d1d1;text color=black
-|tables=scheduleRFAview
+|tables=scheduleRESservice,residentMGH
-;fields=CONCAT('🔸 Resident: ',ResAbbrev,' - ',TaskAbbrev)=name
+;join on= scheduleRESservice.ResAbbrev=residentMGH.copath_id
+;fields=CONCAT(TaskAbbrev,' RES: ',ResAbbrev)=name
+,full_name=description
 ,Date=Date
 ;where=(TaskAbbrev='GYL' OR TaskAbbrev='GYS' OR TaskAbbrev='OB') AND NOT ResAbbrev IN ('0', '-');color=#1730b0;text color=#FFFFFF
-|tables=scheduleRFAview
+|tables=scheduleFELLservice,residentMGH
-;fields=CONCAT('🔹 Fellow: ',FellAbbrev,' - ',TaskAbbrev)=name
+;join on= scheduleFELLservice.FellAbbrev=residentMGH.copath_id
+;fields=CONCAT(TaskAbbrev,' FELL: ',FellAbbrev)=name
+,full_name=description
 ,Date=Date
 ;where=(TaskAbbrev='GYL' OR TaskAbbrev='GYS' OR TaskAbbrev='OB') AND NOT FellAbbrev IN ('0', '-');color=#000000;text color=#FFFFFF
 |format=calendar|}}