Difference between revisions of "EvaluationResAtt"
From MGH Learn Pathology
| Line 20: | Line 20: | ||
,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 ('2', '3') AND scheduleRFA.ResAbbrev='MIC' AND WEEKDAY(scheduleRFA.Date)=0 AND evaluationResAtt._pageName IS NULL | + | |where=YEAR(scheduleRFA.Date)={{#time: Y|{{Timezone}}}} AND QUARTER(scheduleRFA.Date) IN ('2', '3') AND scheduleRFA.ResAbbrev='MIC' AND WEEKDAY(scheduleRFA.Date)=0 AND evaluationResAtt._pageName IS NULL AND WEEKNUMBER(scheduleRFA.Date) <= '{{#time: W}}' |
|order by=scheduleRFA.Date ASC | |order by=scheduleRFA.Date ASC | ||
|rows per page=50 | |rows per page=50 | ||
Revision as of 12:06, July 10, 2020
|
|
|
|
|
Error: The SQL function "WEEKNUMBER()" is not allowed.
|
|
