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?
To-do document containing all to-do's from other documents
This post was last updated for 490 days ago, and the information may already be changed
Related articles
-
- MiscReply
-
I have since tried the "Simple Todo" Template, which seems to work to some degree: for example to pull in tasks from within the last month it creates and embed with the following sql:
SELECT * from blocks WHEREtype= "l" ANDsubtype= "t" ANDcreated>= strftime('%Y%m%d%H%M%S', datetime('now', '-1 month')) AND markdown REGEXP "\* \[ \] \S+" ANDparent_idnot in ( selectidfrom blocks wheresubtype= "t" ) ORDER BYcreatedDESCHope this might help someone.
Looks like I need to learn some sql query language :)
-
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
3 Operatejustcosmic1 updated this reply at 2024-03-03 01:22:34justcosmic1 updated this reply at 2024-03-03 01:19:28justcosmic1 updated this reply at 2024-03-03 01:10:31 -
zxhd86 •
copy and use it:
{{SELECT * FROM blocks WHERE markdown LIKE '%[ ]%' AND subtype = 't' AND type = 'i'}} - Visit all replies
Welcome to here!
Here we can learn from each other how to use SiYuan, give feedback and suggestions, and build SiYuan together.
Signup About