User: Xavier/IssuesQuery

From Genesys Documentation
< User:Xavier
Revision as of 15:09, April 12, 2022 by Xavier (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search
A database query error has occurred. Did you forget to run your application's database schema updater after upgrading?

Query: SELECT `cargo__IssueCategory`.`Name` AS `Name`,COUNT(`cargo__IssueCategory`.`Name`) AS `Count` FROM `cargo___pageData` LEFT OUTER JOIN `cargo__Issue` ON ((`cargo___pageData`.`_pageName`=`cargo__Issue`.`_pageName`)) LEFT OUTER JOIN `cargo__IssueCategory` ON ((`cargo__Issue`.`IssueCategoryId`=`cargo__IssueCategory`.`Id`)) WHERE `cargo__Issue`.`TicketNumber` != AND `cargo__IssueCategory`.`Name`!= AND _creationDate > "2022-01-31" AND _creationDate < "2022-02-28" GROUP BY `cargo__IssueCategory`.`Name`, ORDER BY `cargo__IssueCategory`.`Name`,COUNT(`cargo__IssueCategory`.`Name`) LIMIT 100 Function: CargoSQLQuery::run Error: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY `cargo__IssueCategory`.`Name`,COUNT(`cargo__IssueCategory`.`Name`) LIMI' at line 1 (127.0.0.1)

Retrieved from "https://all.docs.genesys.com/User:Xavier/IssuesQuery (2024-07-27 23:16:58)"