Difference between revisions of "User: Xavier/IssuesQuery"
(Created page with "{{#cargo_query:tables=_pageData,Issue, IssueCategory|join on=_pageData._pageName=Issue._pageName,Issue.IssueCategoryId=IssueCategory.Id|fields=IssueCategory.Name, COUNT(IssueC...") |
|||
Line 1: | Line 1: | ||
− | {{#cargo_query:tables=_pageData,Issue, IssueCategory|join on=_pageData._pageName=Issue._pageName,Issue.IssueCategoryId=IssueCategory.Id|fields=IssueCategory.Name, COUNT(IssueCategory.Name)=Count|where=Issue.TicketNumber !='' AND IssueCategory.Name!='' AND _creationDate > "2022-01-31" AND _creationDate < "2022-02-28"|group by=IssueCategory.Name, | + | {{#cargo_query:tables=_pageData,Issue,IssueCategory|join on=_pageData._pageName=Issue._pageName,Issue.IssueCategoryId=IssueCategory.Id|fields=IssueCategory.Name, COUNT(IssueCategory.Name)=Count|where=Issue.TicketNumber !='' AND IssueCategory.Name!='' AND _creationDate > "2022-01-31" AND _creationDate < "2022-02-28"|group by=IssueCategory.Name, |
|format=list | |format=list | ||
}} | }} |
Latest revision as of 15:09, April 12, 2022
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)