Query All The Things (qatt) v0.10.0 Release for #Obsidian
Features
* Add obsidian handlebars helper and JoinArray SQL function
* Add settings to disable missing DataView and CustomJS plugins notification
* Add EXTRACTLINE and LINEINDEX SQL functions
* Enable processing of DataView Inline fields for use in tasks (`obsidian_markdown_tasks table`)
https://github.com/sytone/obsidian-queryallthethings/releases/tag/0.10.0
Query All The Things #qatt v0.8.8 Plugin Release for #Obsidian
- enable frontmatter data to be queried for page.
- **render:** add 100+ handlebars helpers to rendering templates
- return all query results as collection to be rendered and not just last query
- added help Url so HelpMate support is available.
https://github.com/sytone/obsidian-queryallthethings/releases/tag/0.8.8
Thanks to @TfTHacker for Helpmate plugin 💖 #obsidian #obsidianmd #qatt
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 - sy...
Query All the Things 0.8.0 released.
- JSON Import support added
- re-import on file changes in vault for JSON, MD Tables and CSV
- Import from web endpoints for JSON, MD Tables and CSV
Documentation at https://sytone.github.io/obsidian-queryallthethings/ has been updated.
Details at https://github.com/sytone/obsidian-queryallthethings/releases/tag/0.8.0
@qwxlea @Colman as it turns out yes. You can add a path in settings to a MD file containing a markdown table or CSV contents. On load the contents will be parsed and loaded into a table. The table name is the same as the file. So data/qatt/my_data.md becomes a table called my_data that you can query.
Query All the Things 0.7.1 released.
Enable files in your vaults that contain CSV or just a markdown table to be imported as tables you can query.
So yes. You can make a list of tavern foods and then a code block with this query to get a meal for the night.
SELECT TOP 1 Entry FROM tavern_food ORDER BY RANDOM()
Files can be added via settings for the plugin.
@Colman you might be interested in this. Currently adding the ability for the QATT extension to load CSV files on start into tables you can query.
Just added a CSV of tavern foods and this block to return a random food item. I am considering using CSV files and maybe MD tables as data sources to query and join via SQL.