Difference between revisions of "EvaluationResAtt"
From MGH Learn Pathology
| Line 28: | Line 28: | ||
|where=YEAR(scheduleRFA.Date)='{{#expr: {{#time: Y|{{Timezone}}}} + 0 }}' AND scheduleRFA.ResAbbrev='ADM' AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' | |where=YEAR(scheduleRFA.Date)='{{#expr: {{#time: Y|{{Timezone}}}} + 0 }}' AND scheduleRFA.ResAbbrev='ADM' AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' | ||
|group by=scheduleRFA.weeknumber,scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev | |group by=scheduleRFA.weeknumber,scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev | ||
| − | |order by=scheduleRFA.Date | + | |order by=scheduleRFA.Date DESC |
|rows per page=50 | |rows per page=50 | ||
|format=dynamic table|default=}} | |format=dynamic table|default=}} | ||
Revision as of 10:12, September 25, 2020
|
|
|
|
|
|
|
|
|
