To-do document containing all to-do's from other documents

This post was last updated for 694 days ago, and the information may already be changed

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?

    Welcome to here!

    Here we can learn from each other how to use SiYuan, give feedback and suggestions, and build SiYuan together.

    Signup About
    Please input reply content ...
    • sylwair

      I recently developed a Task List plug-in, I hope it can help you, for more information you can read this blog. And this plug-in has been put on the Marketplace, friends in need are welcome to experience it.

      image.png

      1 Operate
      sylwair updated this reply at 2024-03-25 14:01:39
    • MiscReply
    • zxhd86

      copy and use it:

      {{SELECT * FROM blocks WHERE markdown LIKE '%[ ]%' AND subtype = 't' AND type = 'i'}}
      
    • justcosmic1

      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 :)

    • sylwair

      Thanks for your recognition of this plug-in. I will continue to add more functions to better handle the daily workflow.

      1 Operate
      sylwair updated this reply at 2024-04-11 02:50:27
    • Visit all replies