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

This post was last updated for 250 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 ...
    • zxhd86

      copy and use it:

      {{SELECT * FROM blocks WHERE markdown LIKE '%[ ]%' AND subtype = 't' AND type = 'i'}}
      
    • 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
    • mka
      PRO

      You can save the query inside the global search

    • justcosmic1

      I am also trying to achieve the same thing; so I copied and pasted these queries ; but I get the same error message as the original poster: "Search content block does not exist".

      It would be great to have a built in configurable tasks dashboard or kanban in the future.

      But for now I would just be happy if I could get this to work

      Many thanks in advance for any help

      3 Operate
      justcosmic1 updated this reply at 2024-03-03 01:22:34
      justcosmic1 updated this reply at 2024-03-03 01:19:28
      justcosmic1 updated this reply at 2024-03-03 01:10:31
    • 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 :)

    • justcosmic1

      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!😄

    • xhir

      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
      xhir updated this reply at 2024-03-25 14:01:39
    • justcosmic1

      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
    • xhir

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

      1 Operate
      xhir updated this reply at 2024-04-11 02:50:27
    Please input reply content ...