View Single Post
... and if you have installed these reading projects in your OmniFocus database, a geeklet to display a reminder of the current reading on the OS X desktop might run a command like:
sqlite3 ~/Library/Caches/com.omnigroup.OmniFocus/OmniFocusDatabase2 'select pt.name from (projectinfo p join task t on p.pk=t.persistentidentifier) pt join folder f on pt.folder=f.persistentIdentifier where (f.name="Reading Cycles") and pt.datecompleted is null order by pt.dateDue limit 1;' | sed 's/Read //'
(Attached as a geeklet file below. Note that the SQL schema of the cache may well change in future builds of OmniFocus, requiring a rewrite of any SQL queries of this kind).

--

Last edited by RobTrew; 2011-07-05 at 07:46 AM..