The Omni Group
These forums are now read-only. Please visit our new forums to participate in discussion. A new account will be required to post in the new forums. For more info on the switch, see this post. Thank you!

Go Back   The Omni Group Forums > OmniFocus > OmniFocus 1 for Mac
FAQ Members List Calendar Search Today's Posts Mark Forums Read

 
Actiongroups in overdue? Thread Tools Search this Thread Display Modes
Hey,
is it possible to show actiongroups as a group in overdue?

I'm on OF 1.8 sp

Thx!
 
As you are using OF 1.8, Where in OF would allow you to list (and select) overdue parent tasks with a saveable search like:
tasks where (number of tasks > 0) and (due date ≤ today)
--

Last edited by RobTrew; 2012-07-17 at 07:35 AM..
 
No you don't understand what I'm looking for:

When I'm in overdue view, where all my tasks are shown which are overdue and due soon, there will show the tasks of a 'subproject' and if I want the parent/topic of the subproject to, but not grouped like in project-view - so my question is: can I show a subproject grouped like in project-view?
 
No, I don't believe it is possible to build a perspective that does what you want. You can only get the grouping you want in Project mode, but there is no way to filter out the non-due stuff there. You could find them in Context mode, select them and double-click to open a Project mode window that showed the containing projects, but you would get the entire containing project, not just the overdue action group. 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?

If you don't assign a context to your action groups or projects, you can just look for them in the No Contexts bin with the Due filter, then double-click to get the focused window. Credit for the germ of this idea goes to Curt Clifton in a discussion about how to keep track of projects and action groups with no available actions.
 
Quote:
Originally Posted by whpalmer4 View Post
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
 
Quote:
Originally Posted by RobTrew View Post
I've written the SELECT field1 .. fieldN FROM .... part, but October is making life busier than it was in August)
Also, I've just got around to reading an excellent review of a book about procrastination in the New Yorker ('Later' Oct 11 2010) and I'm inspired to hope that if I wait for Version 2.0 then OmniGroup themselves will have written a SELECT ... FROM ... WHERE ... GROUP BY ... ORDER BY ... report-writer for OmniFocus ...

'OFQL' perhaps ?

--

Last edited by RobTrew; 2010-10-04 at 01:53 PM..
 
I believe that running SQL commands directly against the OF cache file works, though falls deep into "not officially supported" territory. :-)
 
Quote:
Originally Posted by Brian View Post
I believe that running SQL commands directly against the OF cache file works, though falls deep into "not officially supported" territory. :-)
Thank you ! A very helpful pointer - I hadn't noticed that the cache was sqlite.
 
 


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
When is overdue not overdue... tatters OmniFocus 1 for Mac 1 2011-04-20 02:25 PM
Overdue Indicator shows "1", but there's no overdue task verscph OmniFocus 1 for Mac 2 2011-03-31 01:01 AM
Bug regarding due/overdue items scotty321 OmniFocus 1 for Mac 7 2010-02-02 07:32 AM
Due and Overdue pagliere OmniFocus 1 for Mac 2 2009-02-07 06:46 AM
Due Today vs Overdue bankomeister OmniFocus 1 for Mac 5 2008-08-04 07:26 AM


All times are GMT -8. The time now is 04:03 AM.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2019, vBulletin Solutions, Inc.