Difference between revisions of "EvaluationResAtt"
| Line 43: | Line 43: | ||
,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 | ,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=(scheduleRFA.TaskAbbrev='COAG' OR TaskAbbrev='Micro' OR TaskAbbrev='BTS' OR TaskAbbrev='HG' OR TaskAbbrev='HPA' OR TaskAbbrev='HPB') AND YEAR(scheduleRFA.Date)='{{#expr: {{#time: Y|{{Timezone}}}} + 0 }}' AND scheduleRFA.ResAbbrev='DPE' AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' | |where=(scheduleRFA.TaskAbbrev='COAG' OR TaskAbbrev='Micro' OR TaskAbbrev='BTS' OR TaskAbbrev='HG' OR TaskAbbrev='HPA' OR TaskAbbrev='HPB') AND YEAR(scheduleRFA.Date)='{{#expr: {{#time: Y|{{Timezone}}}} + 0 }}' AND scheduleRFA.ResAbbrev='DPE' AND WEEK(scheduleRFA.Date) <= '{{#ifexpr: {{#time: w}} >= 4|{{#expr: {{#time: W|{{Timezone}}}} - 1 }}|{{#expr: {{#time: W|{{Timezone}}}} - 2 }} }}' | ||
| − | |group by=QUARTER(scheduleRFA.Date),scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev | + | |group by=MIN(QUARTER(scheduleRFA.Date)),scheduleRFA.TaskAbbrev,scheduleRFA.StaffAbbrev |
|order by=scheduleRFA.Date DESC | |order by=scheduleRFA.Date DESC | ||
|rows per page=50 | |rows per page=50 | ||
Revision as of 09:08, September 26, 2020
|
|
|
|
|
|
|
|
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 (`cargo__scheduleRFA`.`TaskAbbrev`='COAG' OR TaskAbbrev='Micro' OR TaskAbbrev='BTS' OR TaskAbbrev='HG' OR TaskAbbrev='HPA' OR TaskAbbrev='HPB') AND YEAR(`cargo__scheduleRFA`.`Date`)='2025' AND `cargo__scheduleRFA`.`ResAbbrev`='DPE' AND WEEK(`cargo__scheduleRFA`.`Date`) <= '2' GROUP BY MIN(QUARTER(`cargo__scheduleRFA`.`Date`)),`cargo__scheduleRFA`.`TaskAbbrev`,`cargo__scheduleRFA`.`StaffAbbrev` ORDER BY `cargo__scheduleRFA`.`Date` DESC LIMIT 100000 Function: CargoSQLQuery::run Error: 1111 Invalid use of group function (172.27.81.126:30004) |
|
