Difference between revisions of "CurrentWeekConfCall"

From MGH Learn Pathology
Line 68: Line 68:
 
{{#cargo_query: tables=conference,facultyMGH  
 
{{#cargo_query: tables=conference,facultyMGH  
 
     |join on=conference.presenter=facultyMGH.copath_id
 
     |join on=conference.presenter=facultyMGH.copath_id
     |fields=conference.presenter,conference.color,facultyMGH.full_name,conference.conference,conference.sort=sort
+
     |fields=conference.presenter,conference.color,facultyMGH.fullname,conference.conference,conference.sort=sort
 
     |where=conference.weeknumber='{{#expr: {{#time: W|{{Timezone}}}} - 0 }}' AND conference.conference='Thursday'|default={{:schtableempty}}
 
     |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}}

Revision as of 11:40, November 11, 2019