Difference between revisions of "EvaluationResAtt"
From MGH Learn Pathology
| Line 14: | Line 14: | ||
<tr> | <tr> | ||
<td style="vertical-align:top"> | <td style="vertical-align:top"> | ||
| − | {{#cargo_query:tables= | + | {{#cargo_query:tables=scheduleRFAview,evaluationResAtt |
| − | |join on= | + | |join on=scheduleRFAview.UID=evaluationResAtt.UID |
|fields= | |fields= | ||
| − | + | scheduleRFAview.Date=Week Of | |
| − | ,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}', | + | ,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}',scheduleRFAview.TaskAbbrev,'}}')=Service |
| − | ,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}', | + | ,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFAview.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFAview.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFAview.Date,'{{#urldecode:%7C}}',scheduleRFAview.UID,'}}')=Attending |
| − | |where=YEAR( | + | |where=YEAR(scheduleRFAview.Date)={{#time: Y|{{Timezone}}}} AND scheduleRFAview.ResAbbrev='HUT' AND WEEKDAY(scheduleRFAview.Date)=0 AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFAview.Date) <= '{{#expr: {{#time: W|{{Timezone}}}} - 2 }}' |
| − | |order by= | + | |order by=scheduleRFAview.Date ASC |
|rows per page=50 | |rows per page=50 | ||
|format=dynamic table|default=}} | |format=dynamic table|default=}} | ||
Revision as of 01:05, July 23, 2020
|
|
|
|
|
Error: Table scheduleRFAview not found.
|
|
