Difference between revisions of "learn:schedule-previousweek"

Query: SELECT GROUP_CONCAT(`cargo__scheduleRESservice`.`ResAbbrev`) AS `ResAbbrev)`,`cargo__scheduleRESservice`.`Color` AS `Color`,GROUP_CONCAT(`cargo__residentMGH`.`full_name`) AS `full name)`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleRESservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleRESservice`.`ResAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleRESservice`.`WeekNumber`='11' AND `cargo__scheduleRESservice`.`TaskAbbrev`='CB' GROUP BY `cargo__scheduleRESservice`.`Color` ORDER BY GROUP_CONCAT(`cargo__scheduleRESservice`.`ResAbbrev`),`cargo__scheduleRESservice`.`Color`,GROUP_CONCAT(`cargo__residentMGH`.`full_name`),`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1146 Table 'cargo.cargo__scheduleRESservice' doesn't exist (172.27.81.126:30004)

VAC

Fellow

A

@@ Line 33: / Line 33: @@
      |join on=scheduleCallConference.ResAbbrev=residentMGH.copath_id
      |fields=scheduleCallConference.ResAbbrev,scheduleCallConference.Color,residentMGH.full_name,scheduleCallConference.TaskAbbrev,scheduleCallConference.Sort=sort
-     |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleCallConference.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 1 }}' AND scheduleCallConference.DayNumber='1' AND NOT ResAbbrev='-' AND NOT TaskAbbrev='Call: Autopsy' AND NOT TaskAbbrev='Call: Junior CP' AND NOT TaskAbbrev='Call: BB/CP'|default={{:schtableempty}}
+     |where=YEAR(Date)={{#time: Y|{{Timezone}}}} AND scheduleCallConference.WeekNumber='{{#expr: {{#time: W|{{Timezone}}}} - 1 }}' AND scheduleCallConference.DayNumber='1' AND NOT ResAbbrev='-'  AND NOT TaskAbbrev IN ('Call: Autopsy', 'Call: Junior CP', 'Call: BB/CP', 'HP Journal Club')|default={{:schtableempty}}
      |format=template|order by = sort ASC|template=schtableconfcallLeft}}
 </td>