#qatt

sytonesytone
2024-09-01

Released a new version of Query All The Things a plugin for It fixes some loading order issues and a bug with tags being arrays when only one entry. github.com/sytone/obsidian-que

sytonesytone
2024-02-03

Query All The Things (qatt) v0.10.0 Release for

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`)

github.com/sytone/obsidian-que

sytonesytone
2023-12-02

Query All The Things v0.8.8 Plugin Release for

- 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.

github.com/sytone/obsidian-que

Thanks to @TfTHacker for Helpmate plugin 💖

sytonesytone
2023-11-02

@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.

sytonesytone
2023-09-10

@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. github.com/sytone/obsidian-que

sytonesytone
2023-09-10

@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?

sytonesytone
2023-08-18

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 sytone.github.io/obsidian-quer has been updated.

Details at github.com/sytone/obsidian-que

@Colman

sytonesytone
2023-08-15

@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.

sytonesytone
2023-08-07

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.

sytonesytone
2023-08-06

@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.

sytonesytone
2023-08-06

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.

sytonesytone
2023-08-05

My obsidian plugin 'Query All The Things' is available in the community plugins.

Some documentation is in place at sytone.github.io/obsidian-quer, needs more work so reach out if you have questions!

sytonesytone
2023-08-01

@Colman ok, documentation updates for 'Query All The Things' plugin for Obsidian. Needs more work but it is a start.

sytone.github.io/obsidian-quer

Client Info

Server: https://mastodon.social
Version: 2025.04
Repository: https://github.com/cyevgeniy/lmst