Member
2012-10-08, 12:49 PM
Rob,
This is awesome! For those interested in excluding certain projects from the output... just change
Code:
read overTOTAL weekTOTAL foreTOTAL <<< $($OFQUERY "
SELECT count(*) FROM $JOIN WHERE $OVERMATCHES;
SELECT count(*) FROM $JOIN WHERE $MATCHES;
SELECT count(*) FROM $JOIN WHERE $NEXTMATCHES;
")
to
Code:
EXCLUSIONS="AND p.name NOT IN ('Work Recurring', 'Daily')"
read overTOTAL weekTOTAL foreTOTAL <<< $($OFQUERY "
SELECT count(*) FROM $JOIN WHERE $OVERMATCHES $EXCLUSIONS;
SELECT count(*) FROM $JOIN WHERE $MATCHES $EXCLUSIONS;
SELECT count(*) FROM $JOIN WHERE $NEXTMATCHES $EXCLUSIONS;
")
In this example I've excluded tasks from the "Work Recurring" and "Daily" projects.
Note: this only works for the DUE script. I'm tinkering with the START script but it's not just a copy-paste operation.
/d
Last edited by dbyler; 2012-10-08 at 01:29 PM..