Parameterized queries

Hello,

I would like to be able to use an attribute of the parent block when writing an SQL query in an embed block. For the sake of example, consider I am in the document Trip to the Moon​ and I want to make a query that collects links to it. I would write

select b.* from blocks as b where b.content like "%trip to the moon%" order by updated desc

But I am already in Trip to the Moon​ (a document or a parent block with that name), so ideally I would like to grab the current document's title/name. I would like to replace the literal string "%trip to the moon%"​ with something like :parent.title​. How can I achieve this?

    Related articles

    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 ...
    • ciwoyipang 2

      You can use the Query Widget which will automatically bring out the path

      image.png

      image.png

      image.png

      1 Reply
    • MiscReply
    • 88250

      We are very sorry. Due to some security reasons, LianDi cannot be accessed without logging in.

    • Knuex
      PRO

      The LianDi site requires you to be registered to view it. And to register, it requires a mobile number.

      Is there any way to view that page without registering? @88250

      2 Reply
    • ciwoyipang 1

      SQLQuery 用法记录.sy.zip
      思源 SQL 新人指南 SQL 语法 Query 模板.sy.zip

      The attachment is the exported original text, which can be directly imported.

      Then use the browser opening function of Siyuan to use translation tools

    • Visit all replies