Difference between revisions of "EvaluationResAtt"
| Line 26: | Line 26: | ||
,CONCAT('{{evaluationResAtt-service{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'}}')=Service | ,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,'}}')=Attending | ,CONCAT('{{evaluationResAtt-attending{{#urldecode:%7C}}',scheduleRFA.StaffAbbrev,'{{#urldecode:%7C}}',scheduleRFA.TaskAbbrev,'{{#urldecode:%7C}}',scheduleRFA.Date,'{{#urldecode:%7C}}',scheduleRFA.UID,'{{#urldecode:%7C}}',scheduleRFA.WeekNumber,'}}')=Attending | ||
| − | |where=YEAR(scheduleRFA.Date)={{#time: Y|{{Timezone}} +1}} AND scheduleRFA.ResAbbrev='ADM' AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' AND evaluationResAtt._pageName IS NULL | + | |where=YEAR(scheduleRFA.Date)={{#time: Y|{{Timezone}} + 1}} AND scheduleRFA.ResAbbrev='ADM' AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' AND evaluationResAtt._pageName IS NULL |
|group by=scheduleRFA.weeknumber,scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev | |group by=scheduleRFA.weeknumber,scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev | ||
|order by=scheduleRFA.Date ASC | |order by=scheduleRFA.Date ASC | ||
Revision as of 09:47, September 25, 2020
|
|
|
|
|
|
|
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?
Query: SELECT `cargo__scheduleRFA`.`Date` 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`,'}}') AS `Attending`,`cargo__scheduleRFA`.`Date__precision` AS `Date__precision` FROM `cargo__scheduleRFA` LEFT OUTER JOIN `cargo__evaluationResAtt` ON ((`cargo__scheduleRFA`.`UID`=`cargo__evaluationResAtt`.`UID`)) WHERE YEAR(`cargo__scheduleRFA`.`Date`)=<strong class="error">Error: Invalid time.</strong> AND `cargo__scheduleRFA`.`ResAbbrev`='ADM' AND WEEK(`cargo__scheduleRFA`.`Date`) <= '2' AND `cargo__evaluationResAtt`.`_pageName` IS NULL GROUP BY `cargo__scheduleRFA`.`weeknumber`,`cargo__scheduleRFA`.`TaskAbbrev`,`cargo__scheduleRFA`.`StaffAbbrev` ORDER BY `cargo__scheduleRFA`.`Date` LIMIT 100000 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '<strong class="error">Error: Invalid time.</strong> AND `cargo__scheduleRFA`....' at line 1 (172.27.81.126:30004) |
|
|
