Difference between revisions of "EvaluationResAtt"

Revision as of 09:02, September 26, 2020

Anatomic Pathology		Clinical Pathology		External/Elective Evaluations
		A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT DATE_FORMAT(`cargo__scheduleRFA`.`Date`, '%b %e, %Y') AS `Date`,CONCAT('{{evaluationResAtt-service\|',`cargo__scheduleRFA`.`TaskAbbrev`,'}}') AS `Service`,CONCAT('{{evaluationResAtt-attending\|',`cargo__scheduleRFA`.`StaffAbbrev`,'\|',`cargo__scheduleRFA`.`TaskAbbrev`,'\|',`cargo__scheduleRFA`.`Date`,'\|',`cargo__scheduleRFA`.`UID`,'\|',`cargo__scheduleRFA`.`WeekNumber`,'\|',`cargo__scheduleRFA`.`ResAbbrev`,'}}') AS `Attending` FROM `cargo__scheduleRFA` LEFT OUTER JOIN `cargo__evaluationResAtt` ON ((`cargo__scheduleRFA`.`UID`=`cargo__evaluationResAtt`.`UID`)) WHERE YEAR(`cargo__scheduleRFA`.`Date`)='2025' AND `cargo__scheduleRFA`.`ResAbbrev`='MOR' AND WEEK(`cargo__scheduleRFA`.`Date`) <= '2' AND `cargo__scheduleRFA`.`TaskAbbrev`=COAG GROUP BY `cargo__scheduleRFA`.`weeknumber`,`cargo__scheduleRFA`.`TaskAbbrev`,`cargo__scheduleRFA`.`StaffAbbrev` ORDER BY `cargo__scheduleRFA`.`Date` DESC LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'COAG' in 'WHERE' (172.27.81.126:30004) , A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT DATE_FORMAT(`cargo__scheduleRFA`.`Date`, '%b %e, %Y') AS `Date`,CONCAT('{{evaluationResAtt-service\|',`cargo__scheduleRFA`.`TaskAbbrev`,'}}') AS `Service`,CONCAT('{{evaluationResAtt-attending\|',`cargo__scheduleRFA`.`StaffAbbrev`,'\|',`cargo__scheduleRFA`.`TaskAbbrev`,'\|',`cargo__scheduleRFA`.`Date`,'\|',`cargo__scheduleRFA`.`UID`,'\|',`cargo__scheduleRFA`.`WeekNumber`,'\|',`cargo__scheduleRFA`.`ResAbbrev`,'}}') AS `Attending` FROM `cargo__scheduleRFA` LEFT OUTER JOIN `cargo__evaluationResAtt` ON ((`cargo__scheduleRFA`.`UID`=`cargo__evaluationResAtt`.`UID`)) WHERE YEAR(`cargo__scheduleRFA`.`Date`)='2025' AND `cargo__scheduleRFA`.`ResAbbrev`='MOR' AND WEEK(`cargo__scheduleRFA`.`Date`) <= '2' AND `cargo__scheduleRFA`.`TaskAbbrev`=Micro GROUP BY `cargo__scheduleRFA`.`weeknumber`,`cargo__scheduleRFA`.`TaskAbbrev`,`cargo__scheduleRFA`.`StaffAbbrev` ORDER BY `cargo__scheduleRFA`.`Date` DESC LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'Micro' in 'WHERE' (172.27.81.126:30004) , A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT DATE_FORMAT(`cargo__scheduleRFA`.`Date`, '%b %e, %Y') AS `Date`,CONCAT('{{evaluationResAtt-service\|',`cargo__scheduleRFA`.`TaskAbbrev`,'}}') AS `Service`,CONCAT('{{evaluationResAtt-attending\|',`cargo__scheduleRFA`.`StaffAbbrev`,'\|',`cargo__scheduleRFA`.`TaskAbbrev`,'\|',`cargo__scheduleRFA`.`Date`,'\|',`cargo__scheduleRFA`.`UID`,'\|',`cargo__scheduleRFA`.`WeekNumber`,'\|',`cargo__scheduleRFA`.`ResAbbrev`,'}}') AS `Attending` FROM `cargo__scheduleRFA` LEFT OUTER JOIN `cargo__evaluationResAtt` ON ((`cargo__scheduleRFA`.`UID`=`cargo__evaluationResAtt`.`UID`)) WHERE YEAR(`cargo__scheduleRFA`.`Date`)='2025' AND `cargo__scheduleRFA`.`ResAbbrev`='MOR' AND WEEK(`cargo__scheduleRFA`.`Date`) <= '2' AND `cargo__scheduleRFA`.`TaskAbbrev`=BTS GROUP BY `cargo__scheduleRFA`.`weeknumber`,`cargo__scheduleRFA`.`TaskAbbrev`,`cargo__scheduleRFA`.`StaffAbbrev` ORDER BY `cargo__scheduleRFA`.`Date` DESC LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'BTS' in 'WHERE' (172.27.81.126:30004) , A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT DATE_FORMAT(`cargo__scheduleRFA`.`Date`, '%b %e, %Y') AS `Date`,CONCAT('{{evaluationResAtt-service\|',`cargo__scheduleRFA`.`TaskAbbrev`,'}}') AS `Service`,CONCAT('{{evaluationResAtt-attending\|',`cargo__scheduleRFA`.`StaffAbbrev`,'\|',`cargo__scheduleRFA`.`TaskAbbrev`,'\|',`cargo__scheduleRFA`.`Date`,'\|',`cargo__scheduleRFA`.`UID`,'\|',`cargo__scheduleRFA`.`WeekNumber`,'\|',`cargo__scheduleRFA`.`ResAbbrev`,'}}') AS `Attending` FROM `cargo__scheduleRFA` LEFT OUTER JOIN `cargo__evaluationResAtt` ON ((`cargo__scheduleRFA`.`UID`=`cargo__evaluationResAtt`.`UID`)) WHERE YEAR(`cargo__scheduleRFA`.`Date`)='2025' AND `cargo__scheduleRFA`.`ResAbbrev`='MOR' AND WEEK(`cargo__scheduleRFA`.`Date`) <= '2' AND `cargo__scheduleRFA`.`TaskAbbrev`=HG GROUP BY `cargo__scheduleRFA`.`weeknumber`,`cargo__scheduleRFA`.`TaskAbbrev`,`cargo__scheduleRFA`.`StaffAbbrev` ORDER BY `cargo__scheduleRFA`.`Date` DESC LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'HG' in 'WHERE' (172.27.81.126:30004) , A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT DATE_FORMAT(`cargo__scheduleRFA`.`Date`, '%b %e, %Y') AS `Date`,CONCAT('{{evaluationResAtt-service\|',`cargo__scheduleRFA`.`TaskAbbrev`,'}}') AS `Service`,CONCAT('{{evaluationResAtt-attending\|',`cargo__scheduleRFA`.`StaffAbbrev`,'\|',`cargo__scheduleRFA`.`TaskAbbrev`,'\|',`cargo__scheduleRFA`.`Date`,'\|',`cargo__scheduleRFA`.`UID`,'\|',`cargo__scheduleRFA`.`WeekNumber`,'\|',`cargo__scheduleRFA`.`ResAbbrev`,'}}') AS `Attending` FROM `cargo__scheduleRFA` LEFT OUTER JOIN `cargo__evaluationResAtt` ON ((`cargo__scheduleRFA`.`UID`=`cargo__evaluationResAtt`.`UID`)) WHERE YEAR(`cargo__scheduleRFA`.`Date`)='2025' AND `cargo__scheduleRFA`.`ResAbbrev`='MOR' AND WEEK(`cargo__scheduleRFA`.`Date`) <= '2' AND `cargo__scheduleRFA`.`TaskAbbrev`=HPA GROUP BY `cargo__scheduleRFA`.`weeknumber`,`cargo__scheduleRFA`.`TaskAbbrev`,`cargo__scheduleRFA`.`StaffAbbrev` ORDER BY `cargo__scheduleRFA`.`Date` DESC LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'HPA' in 'WHERE' (172.27.81.126:30004) , A database query error has occurred. Did you forget to run your application's database schema updater after upgrading? Query: SELECT DATE_FORMAT(`cargo__scheduleRFA`.`Date`, '%b %e, %Y') AS `Date`,CONCAT('{{evaluationResAtt-service\|',`cargo__scheduleRFA`.`TaskAbbrev`,'}}') AS `Service`,CONCAT('{{evaluationResAtt-attending\|',`cargo__scheduleRFA`.`StaffAbbrev`,'\|',`cargo__scheduleRFA`.`TaskAbbrev`,'\|',`cargo__scheduleRFA`.`Date`,'\|',`cargo__scheduleRFA`.`UID`,'\|',`cargo__scheduleRFA`.`WeekNumber`,'\|',`cargo__scheduleRFA`.`ResAbbrev`,'}}') AS `Attending` FROM `cargo__scheduleRFA` LEFT OUTER JOIN `cargo__evaluationResAtt` ON ((`cargo__scheduleRFA`.`UID`=`cargo__evaluationResAtt`.`UID`)) WHERE YEAR(`cargo__scheduleRFA`.`Date`)='2025' AND `cargo__scheduleRFA`.`ResAbbrev`='MOR' AND WEEK(`cargo__scheduleRFA`.`Date`) <= '2' AND `cargo__scheduleRFA`.`TaskAbbrev`=HPB GROUP BY `cargo__scheduleRFA`.`weeknumber`,`cargo__scheduleRFA`.`TaskAbbrev`,`cargo__scheduleRFA`.`StaffAbbrev` ORDER BY `cargo__scheduleRFA`.`Date` DESC LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'HPB' in 'WHERE' (172.27.81.126:30004)

You're signed in as '. Need help?'

@@ Line 43: / Line 43: @@
 ,CONCAT('{{evaluationResAtt-service{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'}}')=Service
 ,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFA.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'{{#urldecode:%7C}}',scheduleRFA.WeekNumber,'{{#urldecode:%7C}}',scheduleRFA.ResAbbrev,'}}')=Attending
-|where=YEAR(scheduleRFA.Date)='{{#expr: {{#time: Y|{{Timezone}}}} + 0 }}' AND scheduleRFA.ResAbbrev='MOR' AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' AND scheduleRFA.TaskAbbrev='TaskLMM'
+|where=YEAR(scheduleRFA.Date)='{{#expr: {{#time: Y|{{Timezone}}}} + 0 }}' AND scheduleRFA.ResAbbrev='MOR' AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' AND scheduleRFA.TaskAbbrev=TaskLMM
 |group by=scheduleRFA.weeknumber,scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev
 |order by=scheduleRFA.Date DESC