Difference between revisions of "EvaluationResAtt"
From MGH Learn Pathology
| Line 1: | Line 1: | ||
__NOCACHE__{{DISPLAYTITLE:Evaluation of Attending}}{{#css: table.dataTable tbody tr { background-color: transparent; } table }}{{:dynamictableModified}} | __NOCACHE__{{DISPLAYTITLE:Evaluation of Attending}}{{#css: table.dataTable tbody tr { background-color: transparent; } table }}{{:dynamictableModified}} | ||
| − | |||
<center><table width:100%"> | <center><table width:100%"> | ||
<tr> | <tr> | ||
| Line 27: | Line 26: | ||
,CONCAT('{{evaluationResAtt-service{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'}}')=Service | ,CONCAT('{{evaluationResAtt-service{{#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 scheduleRFA.ResAbbrev='BON' AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' AND WEEK(scheduleRFA.Date) | + | |where=YEAR(scheduleRFA.Date)={{#time: Y|{{Timezone}}}} AND scheduleRFA.ResAbbrev='BON' AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' AND WEEK(scheduleRFA.Date) |
|group by=WEEK(scheduleRFA.Date),scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev | |group by=WEEK(scheduleRFA.Date),scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev | ||
|order by=scheduleRFA.Date ASC | |order by=scheduleRFA.Date ASC | ||
Revision as of 07:48, September 24, 2020
|
|
|
|
|
|
|
|
|
