Difference between revisions of "EvaluationResAtt"

From MGH Learn Pathology
(Created page with "__NOCACHE__{{DISPLAYTITLE:{{CURRENTUSERREALNAME}} Evaluation of Attending}}{{#css: table.dataTable tbody tr { background-color: transparent; } }} {{#cargo_query:tables=schedul...")
 
Line 6: Line 6:
 
,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'}}')=Service
 
,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}',scheduleRFA.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='BYB' 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
 
|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:32, July 8, 2020