Todo totals row: Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
<includeonly> | |||
|- | |- | ||
|{{#ifeq:{{{page}}}|totals|Totals|[[Todo:{{{page}}}|{{{page}}}]]}} | |{{#ifeq:{{{page}}}|totals|Totals|[[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='Yes' AND Date >= '{{{from}}}-01-01' AND DATE <= '{{{to}}}-12-31'}} | |{{#cargo_query:table=Todo|fields=COUNT(*)|where=Done='Yes' AND Date >= '{{{from}}}-01-01' AND DATE <= '{{{to}}}-12-31'}} | ||
</includeonly> | |||