Are there any example queries using JavaScript? I saw it is supported in the change log but couldn't find any English documentation. I would be especially interested in dynamically using the id of the document in which the query is embedded within the query.
Thank you!
The template to query the current document
{{SELECT * FROM BLOCKS WHERE root_id = '.action{.id}'}}
Just playing around with this a bit:
//!js
const query_path = async (path) => {
let notebooks_ = await fetchSyncPost("/api/notebook/lsNotebooks");
let notebooks = notebooks_.data.notebooks;
// Identify your notebook name:
let myNb = notebooks.filter((nb) => nb.name.includes("Notes"));
let myId = myNb[0].id;
let blocks = await fetchSyncPost("/api/filetree/getIDsByHPath", {path: path, notebook: myId});
return blocks.data
}
return query_path("/Resources/PC/Python")
Thank you for the hint! I did get a minimal example going based on this comment in the GH issue.
It appears that the //!js blocks want a list of IDs as return value. The simplest possible example is:
//!js
return ["20231229141513-pnebh92"]
However, we can query the API using the following code and return a list of IDs returned by it:
//!js
const query = async () => {
let blocks = await fetchSyncPost("/api/block/getChildBlocks", {id: "20231229141511-fh9y9hc"});
let data = blocks.data;
let ids = data.map((d) => {return d.id});
return ids
}
return query()
I asked about it in this thread. So far I've managed to use the document id only when using the query plugin, but then I can't render the blocks like the default embed block sql queries do. I don't know how to use the id from within a normal sql query.
Presumably, Javascript could help here, but I could not find any documentation about //!js blocks, and I can't get a minimal working example just from the GH issue (translation by Google).
Welcome to here!
Here we can learn from each other how to use SiYuan, give feedback and suggestions, and build SiYuan together.
Signup About