Difference between revisions of "scheduleNow"
| Line 20: | Line 20: | ||
Pager | Pager | ||
|group by=WeekNumber | |group by=WeekNumber | ||
| − | |where=LocationAbbrev='MGH' AND Year={{#timel: Y|{{Timezone}}}} AND WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}'|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentNew}} | + | |where=LocationAbbrev='MGH' AND Year={{#timel: Y|{{Timezone}}}} AND WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleRESservice_view.Date > '2025-02-02'|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|format=template|template=scheduleResidentNew}} |
|}} | |}} | ||
}} | }} | ||
| Line 34: | Line 34: | ||
|join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id | |join on=scheduleFELLservice.FellAbbrev=residentMGH.copath_id | ||
|fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.TaskAbbrev,residentMGH.full_name,residentMGH.pageid | |fields=scheduleFELLservice.FellAbbrev,scheduleFELLservice.TaskAbbrev,residentMGH.full_name,residentMGH.pageid | ||
| − | |where=YEAR(Date)={{#timel: Y|{{Timezone}}}} AND scheduleFELLservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' |format=template | + | |where=YEAR(Date)={{#timel: Y|{{Timezone}}}} AND scheduleFELLservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleFELLservice.TaskAbbrev='{{#explode:TaskAbbreviation|,|0}}' AND scheduleRESservice_view.Date > '2025-02-02'|format=template |
|group by=scheduleFELLservice.WeekNumber|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|template=scheduleResident}} | |group by=scheduleFELLservice.WeekNumber|default={{schtableempty|{{#explode:TaskAbbreviation|,|2}}}}|template=scheduleResident}} | ||
|}} | |}} | ||
Revision as of 16:56, December 29, 2025
|
|
|
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='AUT' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='BST' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='BR1' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='BR2' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='BR3' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='MGB CV' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='RP' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='CA' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='CB' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='CC' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='DP1 (0-2)' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='DP2 (3-5)' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='DP3 (6-9)' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='EYE' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='FSJ' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='FSS' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='GI1 (1-3)' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='GI2 (4-6)' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='GI3 (7-8) / (1-5)' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='GI4 (9-0) / (6-0)' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='GU1 (0-4)' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='GU2 (5-9)' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='GYL' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='GYS' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='OB' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='HN1 (5-9)' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='HN2 (0-4)' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='HP1 (BM)' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='HP2 (LN)' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='NP' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='NPAUT' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='PP' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='GR-S' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleFELLservice`.`FellAbbrev` AS `FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev` AS `TaskAbbrev`,`cargo__residentMGH`.`full_name` AS `full name`,`cargo__residentMGH`.`pageid` AS `pageid` FROM `cargo__scheduleFELLservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleFELLservice`.`FellAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)=2026 AND `cargo__scheduleFELLservice`.`WeekNumber`='12' AND `cargo__scheduleFELLservice`.`TaskAbbrev`='AP CHIEF' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleFELLservice`.`WeekNumber` ORDER BY `cargo__scheduleFELLservice`.`FellAbbrev`,`cargo__scheduleFELLservice`.`TaskAbbrev`,`cargo__residentMGH`.`full_name`,`cargo__residentMGH`.`pageid` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004) |
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|
|
|
|
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
[1]Faculty schedule displayed using the QGenda API.