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 460 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 :)
-
ranggasan •PRO
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' - 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