Difference between revisions of "EvaluationResAtt"
| Line 35: | Line 35: | ||
,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=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND scheduleRESservice.ResAbbrev='HUT' AND WEEKDAY(scheduleRESservice.Date)=0 AND (scheduleRESservice.TaskAbbrev LIKE '%-E%' OR scheduleRESservice.TaskAbbrev='E' OR scheduleRESservice.TaskAbbrev='ME' OR scheduleRESservice.TaskAbbrev='CAMD') AND evaluationResAtt._pageName IS NULL | + | |where=YEAR(scheduleRESservice.Date)={{#time: Y|{{Timezone}}}} AND WEEK(scheduleRFAview.Date) <= '{{#expr: {{#time: W|{{Timezone}}}} + 0 }}' AND scheduleRESservice.ResAbbrev='HUT' AND WEEKDAY(scheduleRESservice.Date)=0 AND (scheduleRESservice.TaskAbbrev LIKE '%-E%' OR scheduleRESservice.TaskAbbrev='E' OR scheduleRESservice.TaskAbbrev='ME' OR scheduleRESservice.TaskAbbrev='CAMD') 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 09:32, July 27, 2020
|
|
|
|
|
Error: Table scheduleRFAview not found.
|
|
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleRESservice`.`Date` AS `Week Of`,`cargo__scheduleRESservice`.`TaskAbbrev` AS `Rotation`,CONCAT('{{evaluationResAtt-attendingexternal|',`cargo__scheduleRESservice`.`TaskAbbrev`,'|',`cargo__scheduleRESservice`.`Date`,'|',`cargo__scheduleRESservice`.`TaskAbbrev`,'}}') AS `Attending`,`cargo__scheduleRESservice`.`Date__precision` AS `Week Of__precision` FROM `cargo__scheduleRESservice` LEFT OUTER JOIN `cargo__evaluationResAtt` ON ((`cargo__scheduleRESservice`.`TaskAbbrev`=`cargo__evaluationResAtt`.`UID`)) WHERE YEAR(`cargo__scheduleRESservice`.`Date`)=2026 AND WEEK(scheduleRFAview.Date) <= '12' AND `cargo__scheduleRESservice`.`ResAbbrev`='HUT' AND WEEKDAY(`cargo__scheduleRESservice`.`Date`)=0 AND (`cargo__scheduleRESservice`.`TaskAbbrev` LIKE '%-E%' OR `cargo__scheduleRESservice`.`TaskAbbrev`='E' OR `cargo__scheduleRESservice`.`TaskAbbrev`='ME' OR `cargo__scheduleRESservice`.`TaskAbbrev`='CAMD') AND `cargo__evaluationResAtt`.`_pageName` IS NULL GROUP BY `Week Of` ORDER BY `cargo__scheduleRESservice`.`Date` LIMIT 100000 Function: CargoSQLQuery::run Error: 1054 Unknown column 'scheduleRFAview.Date' in 'where clause' (172.27.81.126:30004) |
