Signin Signup

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

This post was last updated for 269 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?

    100 Ask
    1 Collect
    10 Reply
    4
    2
    781 119 20 68 572

    Related articles

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

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

    • 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
    • Visit all replies
    rty16
    Reply
    11
     Article
    11
     Point
    403

    Recent hot