Todo totals row: Difference between revisions

@@ Line 2: / Line 2: @@
 |-
 |{{#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=0 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<>0 AND Date >= '{{{from}}}-01-01' AND DATE <= '{{{to}}}-12-31'}}
 </includeonly>

Revision as of 23:23, 16 September 2023