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?
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 BYcreatedDESC
Hope this might help someone.
Looks like I need to learn some sql query language :)
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.
Welcome to here!
Here we can learn from each other how to use SiYuan, give feedback and suggestions, and build SiYuan together.
Signup About