Difference between revisions of "EvaluationResAtt"
From MGH Learn Pathology
| Line 1: | Line 1: | ||
__NOCACHE__{{DISPLAYTITLE:{{CURRENTUSERREALNAME}} Evaluation of Attending}}{{#css: table.dataTable tbody tr { background-color: transparent; } }} | __NOCACHE__{{DISPLAYTITLE:{{CURRENTUSERREALNAME}} Evaluation of Attending}}{{#css: table.dataTable tbody tr { background-color: transparent; } }} | ||
| − | {{#cargo_query:tables=scheduleRFA,evaluationResAtt | + | {{#cargo_query:tables=scheduleRFA,evaluationResAtt,scheduleRESservice |
| − | |join on=scheduleRFA.UID=evaluationResAtt.UID | + | |join on=scheduleRFA.UID=evaluationResAtt.UID,scheduleRESservice.ResAbbrev=scheduleRFA.ResAbbrev |
|fields= | |fields= | ||
scheduleRFA.Date=Week Of | scheduleRFA.Date=Week Of | ||
| − | ,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}', | + | ,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'}}')=Service |
,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFA.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'}}')=Attending | ,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFA.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'}}')=Attending | ||
|where=YEAR(scheduleRFA.Date)={{#time: Y|{{Timezone}}}} AND QUARTER(scheduleRFA.Date) IN ('3', '4') AND scheduleRFA.ResAbbrev='CYN' AND WEEKDAY(scheduleRFA.Date)=0 AND evaluationResAtt._pageName IS NULL | |where=YEAR(scheduleRFA.Date)={{#time: Y|{{Timezone}}}} AND QUARTER(scheduleRFA.Date) IN ('3', '4') AND scheduleRFA.ResAbbrev='CYN' AND WEEKDAY(scheduleRFA.Date)=0 AND evaluationResAtt._pageName IS NULL | ||
Revision as of 07:33, July 8, 2020
