Difference between revisions of "Schedule"

Query: SELECT `cargo__scheduleRESservice`.`ResAbbrev` AS `ResAbbrev`,`cargo__scheduleRESservice`.`Color` AS `Color`,`cargo__residentMGH`.`full_name` AS `full name` FROM `cargo__scheduleRESservice` LEFT OUTER JOIN `cargo__residentMGH` ON ((`cargo__scheduleRESservice`.`ResAbbrev`=`cargo__residentMGH`.`copath_id`)) WHERE YEAR(Date)='2026' AND `cargo__scheduleRESservice`.`WeekNumber`='5' AND `cargo__scheduleRESservice`.`TaskAbbrev`='VAC' AND scheduleRESservice_view.Date > '2025-02-02' GROUP BY `cargo__scheduleRESservice`.`WeekNumber`,`cargo__scheduleRESservice`.`ResAbbrev` ORDER BY `cargo__scheduleRESservice`.`ResAbbrev`,`cargo__scheduleRESservice`.`Color`,`cargo__residentMGH`.`full_name` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRESservice_view.Date' in 'where clause' (172.27.81.126:30004)

Anatomic pathology (AMP)

Service

AUT

BST

BR1

BR2

BR3

MGB CV

DPA

DPB

DPC

EYE

FSJ

FSS

GI1

GI2

GI3

GI4

GU1

GU2

GYL

GYS

OB

HN1

HN2

HPA

HPB

NP

NPAUT

PP

GR-S

AP CHIEF

Resident

Fellow

Attending^[1]

Call

-

Clinical pathology (LMM)

Service

BTS

COAG

CORE

MICRO

HLA - A

HLA - B

HPA

HPB

HG

MOL: Consult

MOL: HER2

MOL: A non-NGS

MOL: A NGS

MOL: B NGS

MOL: B non-NGS

MOL: B FISH

IMMUNO

CP CHIEF

Resident

Fellow

Attending^[1]

MM408

-

Call

27364
No results Uljon
15433
32443
25338
25338
Louissaint
Louissaint
Sohani
-
-
-
-
-
-
-
MM408
-

^[1]Faculty schedule displayed using the QGenda API.

@@ Line 95: / Line 95: @@
 |join on=scheduleRESservice.ResAbbrev=residentMGH.copath_id
 |fields=scheduleRESservice.ResAbbrev,scheduleRESservice.Color,residentMGH.full_name
-|where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleRESservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='VAC'|group by=scheduleRESservice.WeekNumber,scheduleRESservice.ResAbbrev|default=<center>{{ColorText|''No scheduled vacations''|||3}}</center>|format=template|template=schtable}}
+|where=YEAR(Date)='{{#timel: Y|now}}' AND scheduleRESservice.WeekNumber='{{#expr: {{#timel: W|{{Timezone}}}} - 0 }}' AND scheduleRESservice.TaskAbbrev='VAC' AND scheduleRESservice_view.Date > '2025-02-02'|group by=scheduleRESservice.WeekNumber,scheduleRESservice.ResAbbrev|default=<center>{{ColorText|''No scheduled vacations''|||3}}</center>|format=template|template=schtable}}
 </td>
 <td style="width: 2%">