List todo's by page

I currently have in my daily note template:

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

I would like to modify this so that it lists the todos by page e.g.:

Page Title
- todo 1
- todo 2

Another page
- todo 1
- ...

Another one
- todo1

Is this possible in SiYuan, if so what is the magic invocation?

    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 1

      It is possible to sort by page order, but listing the page titles roughly is not achievable.

      1 Reply
    • zetashift
      VIP Warrior Author

      Ah, alright, thank you!

    • sylwair

      Maybe you can try the Task List plug-in siyuan-plugin-task-list, which can divide todos according to pages or notebooks, and then display them in the dock view on the right.

      previewen.jpg

      1 Operate
      sylwair updated this reply at 2024-05-15 00:18:29