Signin Signup

Parameterized queries

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

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?

‍

alvorithm 10 months

1 Follow

9 Reply

962 102 35 223 595

9 Reply

Parameterized queries

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

alvorithm • 10 months
VIP Warrior Author

Dear @ciwoyipang, thank you so much for making me aware of the query widget. It is a very featureful extension. But I think I did not describe my need clearly. What I am after is that the query block asks its parent for the text "trip to the moon", i.e. that string in the query should be generated automatically from the context.

select * from blocks as b where b.content like "%insert here the title or the name of the parent block%"

So if I put this query inside a document named "The mother of all queries" it would automatically fill in the value and execute

select * from blocks as b where b.content like "%The mother of all queries%"

Do you have an idea on how to customize queries based on the context of the query block (e.g. the parent, or the preceding block)?

PS. in order to have the type column values translated, is it necessary to do it in Siyuan or in the widget code?
MiscReply
Knuex • 7 months
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
alvorithm • 10 months
VIP Warrior Author

Hi again,

I am wondering if using Javascript in the embed block could help here. Because I only get a partial translation and I don't know JS, I don't follow much of what is discussed in the feature request with issue number 9648, proposed by @frostime

@frostime -- wout be possible to dynamically acquire metadata from the environment (current notebook/doc, preceding block, enclosing superblock) for use in a query by using the new //!js embed functionality?

1 Reference

SQL query with JavaScript • alvorithm
ciwoyipang • 10 months • 2

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

1 Reply
Visit all replies