Difference between revisions of "EvaluationResAtt"
From MGH Learn Pathology
| Line 41: | Line 41: | ||
DATE_FORMAT(scheduleRESservice.Date, '%b %e, %Y')=Week Of | DATE_FORMAT(scheduleRESservice.Date, '%b %e, %Y')=Week Of | ||
,scheduleRESservice.TaskAbbrev=Rotation | ,scheduleRESservice.TaskAbbrev=Rotation | ||
| − | ,CONCAT('{{evaluationResAtt- | + | ,CONCAT('{{evaluationResAtt-attendingLMP{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRESservice.Date,'{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'}}')=Attending |
|where=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND WEEK(scheduleRESservice.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 0 }}|{{#expr: {{#time: W|{{Timezone}}}} - 1 }} }}' AND scheduleRESservice.ResAbbrev='NAS' AND WEEKDAY(scheduleRESservice.Date)=0 AND (scheduleRESservice.TaskAbbrev='BB' OR scheduleRESservice.TaskAbbrev='COAG' OR scheduleRESservice.TaskAbbrev='C/M') AND evaluationResAtt._pageName IS NULL | |where=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND WEEK(scheduleRESservice.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 0 }}|{{#expr: {{#time: W|{{Timezone}}}} - 1 }} }}' AND scheduleRESservice.ResAbbrev='NAS' AND WEEKDAY(scheduleRESservice.Date)=0 AND (scheduleRESservice.TaskAbbrev='BB' OR scheduleRESservice.TaskAbbrev='COAG' OR scheduleRESservice.TaskAbbrev='C/M') AND evaluationResAtt._pageName IS NULL | ||
| − | |order by=scheduleRESservice.Date | + | |order by=scheduleRESservice.Date DESC |
|rows per page=50 | |rows per page=50 | ||
|group by=Week Of | |group by=Week Of | ||
| Line 58: | Line 58: | ||
,CONCAT('{{evaluationResAtt-attendingexternal{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRESservice.Date,'{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'}}')=Attending | ,CONCAT('{{evaluationResAtt-attendingexternal{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRESservice.Date,'{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'}}')=Attending | ||
|where=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND WEEK(scheduleRESservice.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 0 }}|{{#expr: {{#time: W|{{Timezone}}}} - 1 }} }}' AND scheduleRESservice.ResAbbrev='MEG' AND WEEKDAY(scheduleRESservice.Date)=0 AND (scheduleRESservice.TaskAbbrev LIKE '%-E%' OR scheduleRESservice.TaskAbbrev='E' OR scheduleRESservice.TaskAbbrev='ME' OR scheduleRESservice.TaskAbbrev='CAMD') AND evaluationResAtt._pageName IS NULL | |where=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND WEEK(scheduleRESservice.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 0 }}|{{#expr: {{#time: W|{{Timezone}}}} - 1 }} }}' AND scheduleRESservice.ResAbbrev='MEG' AND WEEKDAY(scheduleRESservice.Date)=0 AND (scheduleRESservice.TaskAbbrev LIKE '%-E%' OR scheduleRESservice.TaskAbbrev='E' OR scheduleRESservice.TaskAbbrev='ME' OR scheduleRESservice.TaskAbbrev='CAMD') AND evaluationResAtt._pageName IS NULL | ||
| − | |order by=scheduleRESservice.Date | + | |order by=scheduleRESservice.Date DESC |
|rows per page=50 | |rows per page=50 | ||
|group by=Week Of | |group by=Week Of | ||
Revision as of 10:24, September 25, 2020
|
|
|
|
|
|
|
|
|
