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 841 days ago, and the information may already be changed
Related articles
-
OK so after looking at the sql in the template mentioned above, I noticed it does NOT have "{{...}}". So I tried the above sql again; but this time WITHOUT the curly brackets...and viola it works!😄
- 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' -
rty16 •Author
Firstly, I don't know how to do it. I start by typing {{ and paste code but the result is like this
https://i.imgur.com/Yo2jjaF.png
when I click outside it disappears.
Secondly it is a query, so it shows search result. This search result cannot be sorted manually to give some order to it.
This program is so great but without "how-to's" users will be limited to IT programmers who are trained to understand documentation.
1 Reply - 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