View Single Post
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..