I would like it to be possible to retrieve information from a database row based on its primary key.

[Wil24555]

In what scenarios do you need this feature?

I need this feature to better manage projects and tasks. I want Siyuan to be able to fetch information from a database based on its primary key, returning data from other columns (attributes). Currently I can relate databases, but the information only relates data from their primary keys.

Describe the optimal solution

In the option to edit the relationship, there could be an option to choose the primary key and/or an option to choose which column contains the information sought (the information would be in the database row corresponding to the primary key). Similar to the index + match function in an Excel spreadsheet.

This avoids having to keep typing the same information into other databases as the information already exists in another.

The image below is just an example.

Describe the candidate solution

No response

Other information

No response

[Wil24555]

In this case I believe it would not be a two-way relationship.

[TCOTC]

Duplicate of #13645

[Wil24555]

thank you very much!

[88250]

Hello, closing it now does not mean that related improvements will be made in the next version. Instead, it will be considered in #13645. Thank you.

[Wil24555]

Alright! My goal is to make Siyuan better and better. Taking advantage of what is already available in the software.

[Imuvux]

When an entry A is related to another entry B, the other fields of B can be displayed with A's rollup field. Does this meet your requirement?

[Wil24555]

Yes, Thank you very much!