Todo totals row: Difference between revisions
(Created page with "|- |[[Todo:Todo {{page}}|{{page}}]] |{{#cargo_query:table=Todo|fields=COUNT(*)|where=Done='No' AND Date >= '{{{from}}}-01-01' AND DATE <= '{{{to}}}-12-31'}} |{{#cargo_query:ta...") |
No edit summary |
||
| Line 1: | Line 1: | ||
|- | |- | ||
|[[Todo:Todo {{page}}|{{page}}]] | |[[Todo:Todo {{{page}}}|{{{page}}}]] | ||
|{{#cargo_query:table=Todo|fields=COUNT(*)|where=Done='No' AND Date >= '{{{from}}}-01-01' AND DATE <= '{{{to}}}-12-31'}} | |{{#cargo_query:table=Todo|fields=COUNT(*)|where=Done='No' AND Date >= '{{{from}}}-01-01' AND DATE <= '{{{to}}}-12-31'}} | ||
|{{#cargo_query:table=Todo|fields=COUNT(*)|where=Done<>'No' AND Date >= '{{{from}}}-01-01' AND DATE <= '{{{to}}}-12-31'}} | |{{#cargo_query:table=Todo|fields=COUNT(*)|where=Done<>'No' AND Date >= '{{{from}}}-01-01' AND DATE <= '{{{to}}}-12-31'}} | ||
Revision as of 21:52, 2 March 2021
|- |[[Todo:Todo {{{page}}}|{{{page}}}]]
|
Error 1525: Incorrect DATE value: '{{{from}}}-01-01'
Function: CargoSQLQuery::run Query: SELECT COUNT(*) FROM `wm_cargo__Todo` WHERE Done='No' AND Date >= '{{{from}}}-01-01' AND DATE <= '{{{to}}}-12-31' ORDER BY COUNT(*) LIMIT 100
|
Error 1525: Incorrect DATE value: '{{{from}}}-01-01'
Function: CargoSQLQuery::run Query: SELECT COUNT(*) FROM `wm_cargo__Todo` WHERE Done<>'No' AND Date >= '{{{from}}}-01-01' AND DATE <= '{{{to}}}-12-31' ORDER BY COUNT(*) LIMIT 100