How to learn more about sql search query?

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

Hi! I took a lot of time to find out how to search for finished and unfinished tasks through sql query. Is there a specific document for learning sql query? And how to search for a specific color block, for example?

    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 ...
    • avcton

      Yes, would love to have some kind of docs to get more insights into the search power using SQL.
      Can you please share what you have found about querying finished and unfinished tasks?
      It would be highly appreciated.

    • mka
      PRO Author

      Looks like sql search query has been disabled after the update.

      1 Reply
    • avcton

      That's a shame. Was really looking forward to some replacement for Obsidian's DataView 😭

    • mka
      PRO Author

      It's appearing again. You should see the embed block document in the guide and click edit in the sql button. You can see the code. Do the same for all embed blocks there. One of them is for unfinished tasks.

      1 Reply
    • avcton

      Got it!. Thank Youu