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 658 days ago, and the information may already be changed
Related articles
-
Thanks for responding xhir. Yes I just noticed your plugin a couple of days ago so I will try it out too.
I am now understanding how to query my tasks better, as well as create columns within SiYuan so I can display TODO, NEXT, DOING, DONE as well as priority, project or date filtering which can be really helpful in managing tasks. I mention these thing in case they are helpful ideas for your plugin.
I will indeed try the plugin as I mentioned - It will be useful for sure to have a drop down task list available indepenent of which tab I have open, so it should suppliment my task workflow very well.
Thanks again
1 Reply - MiscReply
-
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!😄
-
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 :)
- 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