Difference between revisions of "CurrentWeekConfCall"
From MGH Learn Pathology
| Line 65: | Line 65: | ||
|fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort | |fields=conference.presenter,conference.color,residentMGH.full_name,conference.conference,conference.sort=sort | ||
|where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='4'|default={{:schtableempty}} | |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.daynumber='4'|default={{:schtableempty}} | ||
| + | |format=template|order by = sort ASC|template=schtableconfcallLeft}} | ||
| + | {{#cargo_query: tables=conference,facultyMGH | ||
| + | |join on=conference.presenter=facultyMGH.copath_id | ||
| + | |fields=conference.presenter,conference.color,facultyMGH.full_name,conference.conference,conference.sort=sort | ||
| + | |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.conference='Thursday'|default={{:schtableempty}} | ||
|format=template|order by = sort ASC|template=schtableconfcallLeft}} | |format=template|order by = sort ASC|template=schtableconfcallLeft}} | ||
</td> | </td> | ||
Revision as of 12:39, November 11, 2019
|
Apr 27 Apr 27 |
Apr 28 Apr 28 |
Apr 29 Apr 29 |
May 01 Apr 30 Apr 30 |
May 02 May 01 May 01 |
May 03 May 02 |
May 04 May 03 |
|||||||||||||||||||||||||||||
|
|
|
Error: No field named "full_name" found for the database table "facultyMGH".
|
|
|
|
