Released a new version of Query All The Things a plugin for #obsidian It fixes some loading order issues and a bug with tags being arrays when only one entry. https://github.com/sytone/obsidian-queryallthethings/releases/tag/1.1.1 #qatt
Released a new version of Query All The Things a plugin for #obsidian It fixes some loading order issues and a bug with tags being arrays when only one entry. https://github.com/sytone/obsidian-queryallthethings/releases/tag/1.1.1 #qatt
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
@b I need to write up how to do this better with my plugin as it handles it as part of the query configuration. External file creation works. In place append/prepend/replace is in progress. #qatt #obsidian #obsidianmd
@phd20 it is query all the things (qatt) it is similar to dataview but uses sql as the query language and handlebars as the rendering template. Still a bit rough but getting there. I wanted something to be a bit more flexible for my world planning and daily journal. https://github.com/sytone/obsidian-queryallthethings #qatt #obsidian #obsidianmd
@phd20 in regards to the problem with plugins I have a pending feature for my plugin that renders the result to the file so it is permanent. This way you can turn off the plugin and information is still there. It will no longer be dynamic but available via a simple text editor.
I am looking at adding prepend, append, replace and also allow the current file or other files be the target of the result query and render so you can have separation as well as dynamic. Thoughts? #qatt
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.
Query All the Things 0.6.0 released.
You can now use external files to store querys and templates for better reuse. Internal notes table is better behaved now. Added some wiki links SQL functions.
Working on my TTRPG vault using this, will release that at some point.
My obsidian plugin 'Query All The Things' is available in the community plugins.
Some documentation is in place at https://sytone.github.io/obsidian-queryallthethings/, needs more work so reach out if you have questions!
@Colman ok, documentation updates for 'Query All The Things' plugin for Obsidian. Needs more work but it is a start.
https://sytone.github.io/obsidian-queryallthethings/Examples/dataview-fields/