Obsidian Tasks SQL Powered

Task management for the Obsidian knowledge base. With SQL Powers

📑Documentation

This is a fork of the Tasks plugin for obsidian and will be kept in sync with it where possible. This for provides extended query capabilities and long term should be merged back into the main plugin. Until then enjoy the power of SQL.

Here are some examples of what can be done with this plugin:

• WHERE status->indicator = ' ' AND moment()->[format]('YYYY-MM-DD') = moment(dueDate)->[format]('YYYY-MM-DD')
• WHERE status->indicator = ' ' AND moment(dueDate)->isBetween(moment()->startOf('day').subtract(1, 'days'), moment()->startOf('day').add(14, 'days'))
• WHERE status->indicator = 'x' AND precedingHeader LIKE '%tasks%'
• WHERE status->indicator = ' ' AND moment(dueDate)->[format]('YYYY-MM-DD') = '2021-04-09' AND path LIKE '%GitHub%'
• WHERE description LIKE '%waiting%' OR description LIKE '%waits%' OR description LIKE '%wartet%'

And much much more is possible, go explore and share!

Track tasks across your entire vault. Query them and mark them as done wherever you want. Supports due dates, recurring tasks (repetition), done dates, sub-set of checklist items, and filtering.

You can toggle the task status in any view or query and it will update the source file.

---

For changes in each release, please check the releases page: https://github.com/sytone/obsidian-tasks-x/releases

---

Screenshots

• All screenshots assume the global filter #task which is not set by default (see also installation).
• The theme is Obsidian Atom.

The ACME note has some tasks.

The Important Project note also has some tasks.

The Tasks note gathers all tasks from the vault and displays them using queries.

The Tasks: Create or edit command helps you when editing a task.

Installation

Follow the steps below to install Tasks.

Note: The request to have it added is still pending. Use BRAT for the moment.

1. Search for "Tasks SQL Powered" in Obsidian's community plugins browser
2. Enable the plugin in your Obsidian settings (find "Tasks SQL Powered" under "Community plugins").
3. Check the settings. It makes sense to set the global filter early on (if you want one).
4. Replace the "Toggle checklist status" hotkey with "Tasks: Toggle Done".
   • I recommend you remove the original toggle hotkey and set the "Tasks" toggle to Ctrl + Enter (or Cmd + Enter on a mac).

From BRAT

To install a pre-release, download and enable the Obsidian42 BRAT plugin, add the beta repository sytone/obsidian-tasks-x, and then have BRAT check for updates.

Then..

1. Enable the plugin in your Obsidian settings (find "Tasks SQL Powered" under "Community plugins").
2. Check the settings. It makes sense to set the global filter early on (if you want one).
3. Replace the "Toggle checklist status" hotkey with "Tasks: Toggle Done".
   • I recommend you remove the original toggle hotkey and set the "Tasks" toggle to Ctrl + Enter (or Cmd + Enter on a mac).

Manual installation

1. Download the latest release
2. Extract the obsidian-tasks-x-plugin folder from the zip to your vault's plugins folder: {vault}/.obsidian/plugins/ Note: On some machines the .obsidian folder may be hidden. On MacOS you should be able to press Command+Shift+Dot to show the folder in Finder.
3. Reload Obsidian
4. If prompted about Safe Mode, you can disable safe mode and enable the plugin.

Then..

1. Enable the plugin in your Obsidian settings (find "Tasks SQL Powered" under "Community plugins").
2. Check the settings. It makes sense to set the global filter early on (if you want one).
3. Replace the "Toggle checklist status" hotkey with "Tasks: Toggle Done".
   • I recommend you remove the original toggle hotkey and set the "Tasks" toggle to Ctrl + Enter (or Cmd + Enter on a mac).

User Documentation

For user documentation, please check https://sytone.github.io/obsidian-tasks-x/.

Development

Clone the repository, run yarn to install the dependencies, and run yarn dev to compile the plugin and watch file changes.

Donations

The plugin is completely free to use. If you love it very much and want to pay it forward, please consider donating to an organization of your choice. Two example organizations that you could consider donating to are the Wikimedia Foundation and the Electronic Frontiers Foundation:

1. Support the Wikimedia Foundation
2. Support EFF