Difference between revisions of "EvaluationResAtt"
From MGH Learn Pathology
| Line 3: | Line 3: | ||
|join on=scheduleRESservice.ResAbbrev=scheduleRFA.ResAbbrev,scheduleRFA.UID=evaluationResAtt.UID | |join on=scheduleRESservice.ResAbbrev=scheduleRFA.ResAbbrev,scheduleRFA.UID=evaluationResAtt.UID | ||
|fields= | |fields= | ||
| − | + | scheduleRESservice.Date=Week Of | |
,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'}}')=Service | ,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'}}')=Service | ||
| − | ,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}', | + | ,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRESservice.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'}}')=Attending |
| − | |where=YEAR( | + | |where=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND QUARTER(scheduleRESservice.Date) IN ('3', '4') AND scheduleRESservice.ResAbbrev='CYN' AND WEEKDAY(scheduleRESservice.Date)=0 AND evaluationResAtt._pageName IS NULL |
|order by=scheduleRFA.Date ASC | |order by=scheduleRFA.Date ASC | ||
|rows per page=50 | |rows per page=50 | ||
|group by=Week Of | |group by=Week Of | ||
|format=dynamic table|default=}} | |format=dynamic table|default=}} | ||
Revision as of 07:35, July 8, 2020
