The Omni Group Forums

The Omni Group Forums (http://forums.omnigroup.com/index.php)
-   OmniFocus 1 for Mac (http://forums.omnigroup.com/forumdisplay.php?f=38)
-   -   Actiongroups in overdue? (http://forums.omnigroup.com/showthread.php?t=17232)

lmsboy 2010-08-08 05:05 AM

Actiongroups in overdue?
 
Hey,
is it possible to show actiongroups as a group in overdue?

I'm on OF 1.8 sp

Thx!

RobTrew 2010-08-08 05:40 AM

As you are using OF 1.8, [URL="http://bit.ly/OF-Find2"]Where in OF[/URL] would allow you to list (and select) overdue parent tasks with a saveable search like:
[INDENT]tasks where (number of tasks > 0) and (due date ≤ today)[/INDENT]
[COLOR="White"]--[/COLOR]

lmsboy 2010-08-08 06:09 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?

whpalmer4 2010-10-04 12:56 PM

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.

RobTrew 2010-10-04 01:18 PM

[QUOTE=whpalmer4;86801] 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?[/QUOTE]

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:
[INDENT][I]tasks where (number of tasks > 0) and (it is not root task of its containing project) and (due date ≤ today) and (completed is false)

[/I][/INDENT]
Does that look closer to what is wanted ?

[COLOR="White"]--[/COLOR]

[The variety of needs for customized reports occasionally makes me think of extending the WHERE clause syntax of [URL="http://bit.ly/OF-Find2"]Where in OF[/URL] 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)

RobTrew 2010-10-04 01:51 PM

[QUOTE=RobTrew;86805]I've written the SELECT field1 .. fieldN FROM .... part, but October is making life busier than it was in August)[/QUOTE]

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 ?

[COLOR="White"]--[/COLOR]

Brian 2010-10-05 11:14 PM

I believe that running SQL commands directly against the OF cache file works, though falls deep into "not officially supported" territory. :-)

RobTrew 2010-10-06 05:30 AM

[QUOTE=Brian;86874]I believe that running SQL commands directly against the OF cache file works, though falls deep into "not officially supported" territory. :-)[/QUOTE]

Thank you ! A very helpful pointer - I hadn't noticed that the cache was sqlite.


All times are GMT -8. The time now is 06:22 AM.

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