What is the best way to create one document that would automatically display all to-do blocks scattered in all other documents? Something that would act as a to-do's dashboard.
Do I need to use tags or some page showing search results to achieve it?
What is the best way to create one document that would automatically display all to-do blocks scattered in all other documents? Something that would act as a to-do's dashboard.
Do I need to use tags or some page showing search results to achieve it?
You can use embed block, and then insert this query
For unfinished task
SELECT * FROM blocks WHERE markdown LIKE '%[ ]%' AND subtype = 't' AND type = 'i'
For finished task
SELECT * FROM blocks WHERE markdown LIKE '%[x]%' AND subtype = 't' AND type = 'i'
I am also trying to achieve the same thing; so I copied and pasted these queries ; but I get the same error message as the original poster: "Search content block does not exist".
It would be great to have a built in configurable tasks dashboard or kanban in the future.
But for now I would just be happy if I could get this to work
Many thanks in advance for any help
copy and use it:
{{SELECT * FROM blocks WHERE markdown LIKE '%[ ]%' 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