Various scripts on this board query the cache, and typically start with a property like:

property pstrDBPath : "~/Library/Caches/com.omnigroup.OmniFocus/OmniFocusDatabase2"

AppStore-purchased copies of OmniFocus can not run these scripts without modification.

A possible modification might be something like the following (though this is not bullet-proof):

set pstrDBPath to GetCachePath()

on GetCachePath()
	set strDefaultFolder to "~/Library/Caches/com.omnigroup.OmniFocus"
	set strAppStoreFolder to "~/Library/Caches/com.omnigroup.OmniFocus.MacAppStore"
	set strDBName to "OmniFocusDatabase2"
	
	set strCacheFolder to strDefaultFolder
	if (do shell script ("test -d " & strCacheFolder & "; echo $?")) ≠ "0" then
		set strCacheFolder to strAppStoreFolder
		if (do shell script ("test -d " & strCacheFolder & "; echo $?")) ≠ "0" then return ""
	end if
	
	return strCacheFolder & "/" & strDBName
end GetCachePath

--

Or, I suppose, you could try using "System Events" to read the Bundle identifier key in the info.plist file inside the OmniFocus.app package.

(Looking first in /Applications/OmniFocus.app and then perhaps falling back to ~/Applications/OmniFocus.app if it wasn't found ...)

(But this kind of thing is, of course, hard to test because it is in the nature of the bifurcated bundle identifier problem that any given user only has one version installed, and can't test code for the other ... )

(I have asked the Ninjas whether there is a better solution to automatically detecting whether a user's data is in a com.omnigroup.OmniFocus cache or a com.omnigroup.OmniFocus.MacAppStore cache ...)

UPDATE see FAQ

--