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

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

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

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

    • zxhd86

      copy and use it:

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