Difference between revisions of "EvaluationResAtt"
From MGH Learn Pathology
| Line 21: | Line 21: | ||
,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='SYA' AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFAview.Date) <= '{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' | |where=YEAR(scheduleRFAview.Date)={{#time: Y|{{Timezone}}}} AND scheduleRFAview.ResAbbrev='SYA' AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFAview.Date) <= '{{#expr: {{#time: W|{{Timezone}}}} + 1 }}' | ||
| + | |group by=Week Of,Service,Attending | ||
|order by=scheduleRFAview.Date ASC | |order by=scheduleRFAview.Date ASC | ||
|rows per page=50 | |rows per page=50 | ||
Revision as of 12:57, July 30, 2020
|
|
|
|
|
Error: Table scheduleRFAview not found.
|
|
