Difference between revisions of "EvaluationResAtt"

From MGH Learn Pathology
Line 36: Line 36:
 
,scheduleRESservice.TaskAbbrev=Rotation
 
,scheduleRESservice.TaskAbbrev=Rotation
 
,CONCAT('{{evaluationResAtt-attendingexternal{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRESservice.Date,'{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'}}')=Attending
 
,CONCAT('{{evaluationResAtt-attendingexternal{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRESservice.Date,'{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'}}')=Attending
|where=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND QUARTER(scheduleRESservice.Date) IN ('3', '4')  AND scheduleRESservice.ResAbbrev='CFH' AND WEEKDAY(scheduleRESservice.Date)=0 AND scheduleRESservice.TaskAbbrev='E' AND evaluationResAtt._pageName IS NULL
+
|where=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND QUARTER(scheduleRESservice.Date) IN ('3', '4')  AND scheduleRESservice.ResAbbrev='CFH' AND WEEKDAY(scheduleRESservice.Date)=0 AND scheduleRESservice.TaskAbbrev='E' AND evaluationResAtt._pageName IS NOT NULL
 
|order by=scheduleRESservice.Date ASC
 
|order by=scheduleRESservice.Date ASC
 
|rows per page=50
 
|rows per page=50

Revision as of 07:58, July 8, 2020

Internal Evaluations

   

External Evaluations

   

Error: table "scheduleRESservice" is not in list of table names or aliases.