Difference between revisions of "schedule-conference"
From MGH Learn Pathology
| Line 12: | Line 12: | ||
|tables= conference,residentMGH | |tables= conference,residentMGH | ||
;join on= conference.presenter=residentMGH.copath_id | ;join on= conference.presenter=residentMGH.copath_id | ||
| − | ;fields=CONCAT( | + | ;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date |
;where=conference.conference='Call: Autopsy' OR conference.conference='Call: Junior' | ;where=conference.conference='Call: Autopsy' OR conference.conference='Call: Junior' | ||
;text color=#000000 | ;text color=#000000 | ||
| Line 18: | Line 18: | ||
|tables= conference,residentMGH | |tables= conference,residentMGH | ||
;join on= conference.presenter=residentMGH.copath_id | ;join on= conference.presenter=residentMGH.copath_id | ||
| − | ;fields=CONCAT( | + | ;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date |
;where=conference.conference='Call: Senior' | ;where=conference.conference='Call: Senior' | ||
;text color=#000000 | ;text color=#000000 | ||
| Line 27: | Line 27: | ||
|tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='Thoracic';color=#f79797;text color=black | |tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='Thoracic';color=#f79797;text color=black | ||
|tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='RadPath';color=#66ff96;text color=black | |tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='RadPath';color=#66ff96;text color=black | ||
| − | |tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='Autopsy';color=#e0e0e0;text color=black | + | |tables=conference, residentMGH;join on=conference.presenter = residentMGH.copath_id;fields=CONCAT('一',conference.conference, ' - ', conference.presenter)=name,residentMGH.full_name=description,conference.date=Date;where=conference='Autopsy';color=#e0e0e0;text color=black |
|format=calendar}} | |format=calendar}} | ||
Revision as of 14:04, September 28, 2019
Conference Schedule
1. Autopsy, 2. GPR, 3. Grand Rounds, 4. MPR, 5. Outs, 6. RadPath 7. Thoracic 8. Thursday Didactic 9. Lunch
