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 WHERE type = "l" AND subtype = "t" AND created >= strftime('%Y%m%d%H%M%S', datetime('now', '-1 month')) AND markdown REGEXP "\* \[ \] \S+" AND parent_id not in ( select id from blocks where subtype = "t" ) ORDER BY created DESC
Hope this might help someone.
Looks like I need to learn some sql query language :)
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!😄
Welcome to here!
Here we can learn from each other how to use SiYuan, give feedback and suggestions, and build SiYuan together.
Signup About