Difference between revisions of "EvaluationResAtt"
From MGH Learn Pathology
| Line 20: | Line 20: | ||
<tr> | <tr> | ||
<td style="vertical-align:top; width:43%"> | <td style="vertical-align:top; width:43%"> | ||
| − | {{#cargo_query:tables=scheduleRFA,evaluationResAtt | + | {{#cargo_query:tables=scheduleRFA,evaluationResAtt,facultyMGH |
| − | |join on=scheduleRFA.UID=evaluationResAtt.UID | + | |join on=scheduleRFA.UID=evaluationResAtt.UID,scheduleRFA.StaffAbbrev=facultyMGH.copath_id |
|fields= | |fields= | ||
scheduleRFA.Date=Date | scheduleRFA.Date=Date | ||
,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'}}')=Service | ,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'}}')=Service | ||
| − | ,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}', | + | ,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',facultyMGH.fullname,'{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFA.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'}}')=Attending |
|where=YEAR(scheduleRFA.Date)={{#time: Y|{{Timezone}}}} AND scheduleRFA.ResAbbrev='SYA' AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 5|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' | |where=YEAR(scheduleRFA.Date)={{#time: Y|{{Timezone}}}} AND scheduleRFA.ResAbbrev='SYA' AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 5|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' | ||
|group by=WEEK(scheduleRFA.Date) | |group by=WEEK(scheduleRFA.Date) | ||
Revision as of 07:47, September 24, 2020
|
|
|
|
|
|
|
|
|
