Query All The Things 1.0 Release

A new release of Query All The Things has been made. This enables the tables and query engine to be accessed from other plugins like inline scripts and quick add expanding the use of your data. There is also an inital version where the rendered query output is saved to file.

Query All The Things 0.10.0 Release

A new release of Query All The Things has been made. This adds some new helpers for handlebars as well as some new SQL functions to make the queries more powerful.

Plugin 'Query All The Things (qatt)' avaliable in community plugins

The ‘Query All The Things’ (qatt) plugin is now available by browsing the community plugins. It is still a bit rough around the edges but getting there. It handles all the needs I have at the moment and I will be updating and fixing any issues I see.

Obsidian Plugin Query All the Things (Qatt)

I have created a new plugin for Obsidian. It uses AlaSQL to query your data stored in Obsidian, once the data is queries you can use templates to display it how you want.

There are other great solutions out there that do similar things like Dataview but I wanted a bit more customization.

Head over to my repo sytone/obsidian-queryallthethings: Query all your data stored in Obsidian, this plugin allows SQL based queries against the data collections available in Obsidian and Dataview. Output can then be rendered by Handlebars (github.com) to install the current version. I will work to get it published at some point in Obsidian itself.

Change default shell for OpenSSH on Windows

If you are using OpenSSH on Windows the default shell used when connecting is cmd.exe. To update Windows to use something different you need to update the registry and restart the OpenSSH service.

Managing hugo blog entries in Obsidian

To make using and blogging simpler I have made some scripts, templates and quickadd commands to make a new article for my blog and then be able to run a PowerShell script to publish it.

Extract tasks from Obsidian vault with Github actions

I wanted to be able to pull my tasks out of my vault as a summary view, this can open up future automation options for me. However as I use multiple devices no single place was great and if I am on my phone it makes it harder.

As I am synchronizing my vault with git I decided to use a github workflow to help me out. I have it setup to run once a hour and extract all the tasks that are visible in the Obsidian Tasks plugin. These can be found as they always have the global task tag in them. In this example I use #task, update the regex as needed.

Cleanup Empty Azure Resource Groups

I needed to cleanup empty groups on a test subscription I had, using the Azure Cloud shell the following script will do it for you.

 az group list -o tsv --query [].name | % {$resources = az resource list -g $_ -o table; if($resources) {"$_ has Resources"} else {"$_ has no resources"; az group delete -n $_ -y --no-wait}}

Import multiple calendars to Obsidian with Power Automate

I have a family calendar in iCloud and my personal one in Outlook. I want to have a easy way to see them in Obsidian. To enable this scenario I have used Power Automate and the Template plugin with some javascript to generate the calendar for every day and then allow it to be imported. This model could be used for anything else you may want to import into Obsidian with the bonus of it working on mobile as well.