Signin Signup

All aliases in current page

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

I use aliases to mark examples (alias='example') how can I write a query to select all existing ones on a current page?
I try something like SELECT * FROM blocks where content='my page name' and alias='example'

    20 Ask
    1 Reply
    326 31 30 53 209

    Related articles

    1 Reply
    All aliases in current page

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

      image.png

      select * from blocks as A where A.root="<the page id>" and A.alias
    Fermns
    Reply
    0
     Article
    1
     Point
    485

    Recent hot