Signin Signup

How to bind primary key and deletion from a database row to the binded document?

The way I want to interact with my notes or documents are via a database, but I encountered two problems:

When I change the primary key field in the database row, it doesn't update the document name. I want this to be bidirectional. Is this possible?
When I delete a database row, it doesn't delete the binded document. I want this to be bidirectional as well. Is this possible?

ThunderEmperor 2 days

20 Ask

1 Reply

30 3 27

Related articles

1 Reply

How to bind primary key and deletion from a database row to the binded document?

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

Bharani • 1 hour • 1 Comment

** **Hi there! ** **

** **The short answer is no, this bidirectional behavior is currently not supported by native design, and this is an ** **

** intentional architectural decision in SiYuan. **

Dynamic vs. Static Anchor Text: • By default, when a document is bound to a database row, the primary key uses dynamic anchor text that reflects the real document title. If you change the document title inside the document itself, the database row does update automatically. • However, if you type directly into the primary key cell in the database, SiYuan assumes you want to assign a static anchor text (alias) specific to this database view (see issue #10049 https://github.com/siyuan- note/siyuan/issues/10049). • It stores this as a custom attribute (custom-av-static-text) rather than modifying the underlying document title. This allows the same document to have different descriptive labels across multiple database views without altering the file itself. • Tip: If you clear the text in the primary key cell, it will revert to dynamically mirroring the document's actual title

Bharani • 1 hour

ThunderEmperor

Recent hot