How do you get backlink references to show in the Siyuan App?

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

Hey Everyone,

I'm trying to recreate my logseq experience on Siyuan and I was wondering if you can ge the backlink references to automatically show up on the sidebar or in the page itself and I can also edit it inline?

Example:

image.png

    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 ...
    • Latizes
      VIP Warrior Author

      I guess I figured it partially out

      Where I've used SELECT * FROM blocks WHERE content LIKE '%Benefits of Cloud Computing%'

      However the results repeats itself, so I'm wondering what would I add in there to eliminate the amount of repeats?

      image.png

      2 Reply
    • MiscReply
    • dwinkl
      PRO

      Try adding

      AND type = 'p' (see documentation for advanced search - type filtering for additional parameters)

      If you want to select multiple types try

      AND type in ('p', 'h', 'd') for documents, headings and paragraphs

    • Latizes
      VIP Warrior Author

      Thanks for the tip, what would be the query to query all the blocks that's referenced to the page? In my picture it would be all the blocks or the references related to [[CTC News]]?

      Sorry I'm not too familair with SQL

    • dwinkl
      PRO

      There is an icon that will open the backlinks panel when clicked: image.png

      For me it's in the lower right but not sure if I moved it. To query only backlinks to the current document (and not blocks within it) I have a template

      {{SELECT * FROM BLOCKS WHERE markdown like '%((.action{.id}%))%'}}
      
    • Visit all replies