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>