View Single Post
The fastest approach, which works even when OmniFocus is not running, is likely to be:

Code:
set strProjects to do shell script "sqlite3 ~/Library/Caches/com.omnigroup.OmniFocus/OmniFocusDatabase2 " & ¬
	quoted form of "select tp.name from (task t join projectinfo p on t.projectinfo=p.pk) tp left join folder f on tp.folder=f.persistentidentifier where f.active=1 and tp.status='active'  order by tp.name"
This may not, however, be very future-proof, as the cache schema can change from one build of OF to another.

--

Last edited by RobTrew; 2011-05-03 at 08:33 PM..