Difference between revisions of "EvaluationResAtt"

Revision as of 07:56, July 8, 2020

Internal Evaluations		External Evaluations
		Error: table "scheduleRESservice" is not in list of table names or aliases.

@@ Line 31: / Line 31: @@
 <td>
 {{#cargo_query:tables=scheduleRFA,evaluationResAtt
-|join on=scheduleRFA.UID=evaluationResAtt.UID
+|join on=scheduleRESservice.TaskAbbrev=evaluationResAtt.UID
 |fields=
-scheduleRFA.Date=Week Of
+scheduleRESservice.Date=Week Of
-,CONCAT('{{schedule-TaskAbbrev{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'}}')=Service
+,scheduleRESservice.TaskAbbrev=Rotation
-,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFA.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'}}')=Attending
+,CONCAT('{{evaluationResAtt-attendingexternal{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRESservice.Date,'{{#urldecode:%7C}}',scheduleRESservice.TaskAbbrev,'}}')=Attending
-|where=YEAR(scheduleRFA.Date)={{#time: Y|{{Timezone}}}} AND QUARTER(scheduleRFA.Date) IN ('3', '4')  AND scheduleRFA.ResAbbrev='CFH' AND WEEKDAY(scheduleRFA.Date)=0 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 evaluationResAtt._pageName IS NULL
-|order by=scheduleRFA.Date ASC
+|order by=scheduleRESservice.Date ASC
 |rows per page=50
 |group by=Week Of