rlow

@rhyd - There was no Caches folder in the path you pointed me to, but when I searched for OmniFocusDatabase I found OmniFocusDatabase.db at the following path:

/Users/rlow/Library/Group Containers/34YW5XSRB7.com.omnigroup.OmniFocus/com.omnigroup.OmniFocus3/com.omnigroup.OmniFocusModel

@rhydFirst off thank you for building this and taking the time to reply. 

When I copy and paste that line into terminal, it doesn't return anything.  I'm not sure what I'm doing wrong.  I use Omnisync, their server for synchronizing between devices if that matters.

If I go into Omnifocus, then the file dropdown menu and hold alt, it gives me the option to "Show "Omnifocus.ofocus" in Finder" - when I choose that option it takes me to /Users/rlow/Library/Containers/com.omnigroup.OmniFocus3/Data/Library/Application Support/OmniFocus

This script looks awesome, I'm excited to get it to work for me.

I'm also getting a "Unable to open database file" when using any commands @rhyd

Alfred 4.1

Omnifocus 3.9.1

Here's my error log:

[09:04:09.539] Logging Started...
[09:04:14.320] Search OmniFocus[Script Filter] Queuing argument ''
[09:04:14.480] Search OmniFocus[Script Filter] Script with argv '(null)' finished
[09:04:14.482] ERROR: Search OmniFocus[Script Filter] Code 1: .
09:04:14 workflow.py:2061 DEBUG    ---------- Search OmniFocus (2.0.6) ----------
09:04:14 workflow.py:1468 DEBUG    reading settings from /Users/rlow/Library/Application Support/Alfred/Workflow Data/net.rhydlewis.alfred.searchomnifocus/settings.json
09:04:14 workflow.py:2343 DEBUG    update check not due
09:04:14 search.py:48 DEBUG    Started workflow
09:04:14 search.py:179 DEBUG    [u'-t', u'i']
09:04:14 workflow.py:1695 DEBUG    loading cached data: /Users/rlow/Library/Caches/com.runningwithcrayons.Alfred/Workflow Data/net.rhydlewis.alfred.searchomnifocus/__workflow_latest_version.cpickle
09:04:14 search.py:57 INFO     Using OmniFocus version 3
09:04:14 search.py:193 DEBUG    Using stored icon_root:'/Applications/OmniFocus.app/Contents/Resources'
09:04:14 search.py:147 DEBUG    Searching inbox
09:04:14 search.py:80 DEBUG    SELECT t.persistentIdentifier AS id, t.name AS name, t.dateCompleted, t.blockedByFutureStartDate AS blocked_by_future_start_date, p.name AS project_name, t.flagged, t.dateToStart AS start_date, t.inInbox AS in_inbox, t.effectiveInInbox AS effective_in_inbox, t.effectiveDateToStart AS effective_start_date, t.childrenCountAvailable AS child_count, t.blocked AS blocked, pi.status AS status, t.effectiveFlagged, t.dateModified AS modified, t.containingProjectInfo AS parent, t.dateDue AS due_date FROM ((task tt left join projectinfo pi on tt.containingprojectinfo=pi.pk) t left join task p on t.task=p.persistentIdentifier)  WHERE (t.effectiveInInbox = 1 OR t.inInbox = 1) ORDER BY t.name ASC
09:04:14 search.py:211 DEBUG    OmniFocus db not found at /Users/rlow/Library/Containers/com.omnigroup.OmniFocus3/Data/Library/Application Support/OmniFocus/OmniFocus Caches/OmniFocusDatabase; using /Users/rlow/Library/Containers/com.omnigroup.OmniFocus3.MacAppStore/Data/Library/Application Support/OmniFocus/OmniFocus Caches/OmniFocusDatabase instead
09:04:14 search.py:221 DEBUG    /Users/rlow/Library/Containers/com.omnigroup.OmniFocus3.MacAppStore/Data/Library/Application Support/OmniFocus/OmniFocus Caches/OmniFocusDatabase
09:04:14 workflow.py:2080 ERROR    unable to open database file
Traceback (most recent call last):
  File "/Users/rlow/Library/Application Support/Alfred/Alfred.alfredpreferences/workflows/user.workflow.D3F61BAF-27A3-4BE8-9E69-423ED4CF81D2/workflow/workflow.py", line 2073, in run
    func(self)
  File "search.py", line 63, in main
    get_results(sql, args.type, factory)
  File "search.py", line 81, in get_results
    results = run_query(sql)
  File "search.py", line 233, in run_query
    conn = sqlite3.connect(db_path)
OperationalError: unable to open database file
09:04:14 workflow.py:2103 DEBUG    ---------- finished in 0.024s ----------
[09:04:14.484] Search OmniFocus[Script Filter] <?xml version="1.0" encoding="utf-8"?>
<items><item valid="no"><title>Error in workflow 'Search OmniFocus'</title><subtitle>unable to open database file</subtitle><icon>/System/Library/CoreServices/CoreTypes.bundle/Contents/Resources/AlertStopIcon.icns</icon></item></items>