Difference between revisions of "EvaluationResAtt"

Revision as of 15:52, September 23, 2020

Anatomic Pathology		Clinical Pathology		External/Elective Evaluations
Error: Table scheduleRFAview not found.

@@ Line 36: / Line 36: @@
 </td>
 <td style="vertical-align:top; width:33%">
-{{#cargo_query:tables=scheduleRFAview,evaluationResAtt
+{{#cargo_query:tables=scheduleRESservice,evaluationResAtt
-|join on=scheduleRFAview.UID=evaluationResAtt.UID
+|join on=scheduleRESservice.TaskAbbrev=evaluationResAtt.UID
 |fields=
-scheduleRFAview.Date=Date
+scheduleRESservice.Date=Week Of
-,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}',scheduleRFAview.TaskAbbrev,'}}')=Service
+,scheduleRESservice.TaskAbbrev=Rotation
-,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFAview.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFAview.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFAview.Date,'{{#urldecode:%7C}}',scheduleRFAview.UID,'}}')=Attending
+,CONCAT('{{evaluationResAtt-attendingexternal{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRESservice.Date,'{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'}}')=Attending
-|where=YEAR(scheduleRFAview.Date)={{#time: Y|{{Timezone}}}} AND scheduleRFAview.ResAbbrev='MEG' AND evaluationResAtt._pageName IS NULL AND WEEK(scheduleRFAview.Date) <= '{{#ifexpr: {{#time: w}} >= 5|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}'
+|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='BB') AND evaluationResAtt._pageName IS NULL
-|group by=WEEK(scheduleRFAview.Date)
+|order by=scheduleRESservice.Date ASC
-|order by=scheduleRFAview.Date ASC
 |rows per page=50
+|group by=Week Of
 |format=dynamic table|default=}}
 </td>