Difference between revisions of "EvaluationResAtt"
From MGH Learn Pathology
| Line 43: | Line 43: | ||
,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFA.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'{{#urldecode:%7C}}',scheduleRFA.WeekNumber,'{{#urldecode:%7C}}',scheduleRFA.ResAbbrev,'}}')=Attending | ,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFA.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'{{#urldecode:%7C}}',scheduleRFA.WeekNumber,'{{#urldecode:%7C}}',scheduleRFA.ResAbbrev,'}}')=Attending | ||
|where=(scheduleRFA.TaskAbbrev='COAG' OR TaskAbbrev='Micro' OR TaskAbbrev='BTS' OR TaskAbbrev='HG' OR TaskAbbrev='HPA' OR TaskAbbrev='HPB') AND YEAR(scheduleRFA.Date)='{{#expr: {{#time: Y|{{Timezone}}}} + 0 }}' AND scheduleRFA.ResAbbrev='DPE' AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' | |where=(scheduleRFA.TaskAbbrev='COAG' OR TaskAbbrev='Micro' OR TaskAbbrev='BTS' OR TaskAbbrev='HG' OR TaskAbbrev='HPA' OR TaskAbbrev='HPB') AND YEAR(scheduleRFA.Date)='{{#expr: {{#time: Y|{{Timezone}}}} + 0 }}' AND scheduleRFA.ResAbbrev='DPE' AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' | ||
| − | |group by= | + | |group by=QUARTER(scheduleRFA.Date),scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev |
|order by=scheduleRFA.Date DESC | |order by=scheduleRFA.Date DESC | ||
|rows per page=50 | |rows per page=50 | ||
Revision as of 09:09, September 26, 2020
|
|
|
|
|
|
|
|
|
