Guest
2010-10-04, 01:18 PM
Quote:
Originally Posted by whpalmer4
Rob's script with his suggested query works pretty well for this, except it grabs overdue projects and projects that would be overdue if not on hold or dropped, so you have to do some picking and choosing of the results. Rob, any suggestions for a better search?
|
We can certainly winnow out the projects ("root tasks") lurking amongst the tasks, (and still focus on the containing projects of the action groups we really want) by adding a clause:
tasks where (number of tasks > 0) and (it is not root task of its containing project) and (due date ≤ today) and (completed is false)
Does that look closer to what is wanted ?
--
[The variety of needs for customized reports occasionally makes me think of extending the WHERE clause syntax of
Where in OF to include something like SELECT field1, field2 FROM (folders|projects|tasks|contexts) WHERE ... GROUP BY ... ORDER BY ... and get it to generate custom text or OmniOutliner reports. (The latter could include clickable OmniFocus:///object_type/ID links back into the GUI]
(I've written the SELECT field1 .. fieldN FROM part ... but October is making life busier than it was in August)
Last edited by RobTrew; 2012-07-17 at 07:36 AM..
Reason: added (completed is false) to the search filter