Difference between revisions of "EvaluationResAtt"

From MGH Learn Pathology
Line 20: Line 20:
 
,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}',scheduleRFAview.TaskAbbrev,'}}')=Service
 
,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}',scheduleRFAview.TaskAbbrev,'}}')=Service
 
,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFAview.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFAview.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFAview.Date,'{{#urldecode:%7C}}',scheduleRFAview.UID,'}}')=Attending
 
,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFAview.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFAview.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFAview.Date,'{{#urldecode:%7C}}',scheduleRFAview.UID,'}}')=Attending
|where=YEAR(scheduleRFAview.Date)={{#time: Y|{{Timezone}}}} AND scheduleRFAview.ResAbbrev='HUT' AND WEEKDAY(scheduleRFAview.Date)=0 AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFAview.Date) <= '{{#expr: {{#time: W|{{Timezone}}}} - 1 }}'
+
|where=YEAR(scheduleRFAview.Date)={{#time: Y|{{Timezone}}}} AND scheduleRFAview.ResAbbrev='HUT' AND WEEKDAY(scheduleRFAview.Date)=0 AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFAview.Date) <= '{{#expr: {{#time: W|{{Timezone}}}} - 2 }}'
 
|order by=scheduleRFAview.Date ASC
 
|order by=scheduleRFAview.Date ASC
 
|rows per page=50
 
|rows per page=50

Revision as of 06:33, July 27, 2020

Internal Evaluations

   

External/Elective Evaluations

Error: Table scheduleRFAview not found.