embed block query for child document

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

I want to simulate this with a embed block sql query for search inside all childs for a keyword:

image.png

For example: I want to search for a work inside the Sep (month) and all child below. I know I can do it through ctrl-F but I need to see the context through embed block.

    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 ...
    • mka
      PRO Author

      It's given 3 results. I have only two "palavra" in the child.

      image.png

    • MiscReply
    • n4v41
      PRO

      i did some tests and a query like this will work:

      to do taks

      SELECT * FROM blocks WHERE hpath LiKE '/daily note/2023/sep%'  AND markdown LIKE '%[ ]%' AND subtype = 't' AND type = 'i';
      

      done tasks

      SELECT * FROM blocks WHERE hpath LiKE '/daily note/2023/sep%'  AND markdown LIKE '%[X]%' AND subtype = 't' AND type = 'i';