Difference between revisions of "EvaluationResAtt"
From MGH Learn Pathology
| Line 30: | Line 30: | ||
</td> | </td> | ||
<td> | <td> | ||
| − | {{#cargo_query:tables= | + | {{#cargo_query:tables=scheduleRESservice,evaluationResAtt |
|join on=scheduleRESservice.TaskAbbrev=evaluationResAtt.UID | |join on=scheduleRESservice.TaskAbbrev=evaluationResAtt.UID | ||
|fields= | |fields= | ||
| Line 36: | Line 36: | ||
,scheduleRESservice.TaskAbbrev=Rotation | ,scheduleRESservice.TaskAbbrev=Rotation | ||
,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=scheduleRESservice.TaskAbbrev='E' AND evaluationResAtt._pageName IS NULL | + | |where=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND QUARTER(scheduleRESservice.Date) IN ('3', '4') AND scheduleRESservice.ResAbbrev='CFH' AND WEEKDAY(scheduleRESservice.Date)=0 AND scheduleRESservice.TaskAbbrev='E' AND evaluationResAtt._pageName IS NULL |
|order by=scheduleRESservice.Date ASC | |order by=scheduleRESservice.Date ASC | ||
|rows per page=50 | |rows per page=50 | ||
Revision as of 07:59, July 8, 2020
|
|
|
|
|
|
