Skip to content

Instantly share code, notes, and snippets.

@John07
Last active August 29, 2015 14:00
Show Gist options
  • Save John07/2144e472c2a4ac39e60e to your computer and use it in GitHub Desktop.
Save John07/2144e472c2a4ac39e60e to your computer and use it in GitHub Desktop.
Count the number of open tasks in Wunderlist 2
# counts the number of open tasks in Wunderlist across all lists
# (pretty sure there's a more elegant way of doing this but works for now)
sqlite3 "/Users/USERNAME/Library/Containers/com.wunderkinder.wunderlistdesktop/Data/Library/Application Support/Wunderlist/WKModel.sqlite" "select ZTITLE from ZRESOURCE where ZOWNER1 is not 1 and ZPARENTTASK is null and ZCOMPLETEDAT is null" | wc -l
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment