stringify(value)
The stringify
function will convert the provided value to a JSON string.
In this example it takes the stat
property of the first note found and renders it as a JSON blob. This can be handy to explore objects if you are not sure what is available.
markdown
```qatt
query: SELECT TOP 1 stringify(stat) AS statPropertyAsJsonString FROM obsidian_notes
template: |
{{#each result}}{{statPropertyAsJsonString}}{{/each}}
```
will result in:
text
{"ctime":1670345758620,"mtime":1670345758620,"size":316}