Difference between revisions of "schedule-conference"
From MGH Learn Pathology
| Line 11: | Line 11: | ||
;where=conference='GPR' | ;where=conference='GPR' | ||
;color=#ffb973;text color=black | ;color=#ffb973;text color=black | ||
| + | |||
| + | |tables= conference,facultyMGH | ||
| + | ;join on= conference.presenter=facultyMGH.copath_id | ||
| + | ;fields=CONCAT(conference.conference, ' - ', conference.presenter)=name,conference.type=description,conference.date=Date | ||
| + | ;where=conference.conference='Thursday' | ||
| + | ;text color=#000000 | ||
| + | ;color=#ffc65c | ||
| + | |||
|tables= conference,residentMGH | |tables= conference,residentMGH | ||
;join on= conference.presenter=residentMGH.copath_id | ;join on= conference.presenter=residentMGH.copath_id | ||