I want to simulate this with a embed block sql query for search inside all childs for a keyword:
For example: I want to search for a work inside the Sep (month) and all child below. I know I can do it through ctrl-F but I need to see the context through embed block.
i did some tests and a query like this will work:
to do taks
SELECT * FROM blocks WHERE hpath LiKE '/daily note/2023/sep%' AND markdown LIKE '%[ ]%' AND subtype = 't' AND type = 'i';
done tasks
SELECT * FROM blocks WHERE hpath LiKE '/daily note/2023/sep%' AND markdown LIKE '%[X]%' AND subtype = 't' AND type = 'i';
Welcome to here!
Here we can learn from each other how to use SiYuan, give feedback and suggestions, and build SiYuan together.
Signup About