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( | + | |where=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND WEEK(scheduleRESservice.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 0 }}|{{#expr: {{#time: W|{{Timezone}}}} - 1 }} }}' AND scheduleRESservice.ResAbbrev='SYA' AND evaluationResAtt._pageName IS NULL |
|group by=scheduleRFAview.WeekNumber,scheduleRFAview.TaskAbbrev,scheduleRFAview.StaffAbbrev | |group by=scheduleRFAview.WeekNumber,scheduleRFAview.TaskAbbrev,scheduleRFAview.StaffAbbrev | ||
|order by=scheduleRFAview.Date ASC | |order by=scheduleRFAview.Date ASC | ||
Revision as of 13:15, July 30, 2020
|
|
|
|
|
Error: Table scheduleRFAview not found.
|
|
