Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Closed
Wil24555 opened this issue Dec 31, 2024 · 5 comments

Comments

@Wil24555
Copy link

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.

Correspondência através da chave primária

Describe the candidate solution

No response

Other information

No response

@Wil24555
Copy link
Author

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

@TCOTC
Copy link
Contributor

TCOTC commented Dec 31, 2024

Duplicate of #13645

@Wil24555
Copy link
Author

Wil24555 commented Jan 1, 2025

thank you very much!

@88250
Copy link
Member

88250 commented Jan 1, 2025

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
Copy link
Author

Wil24555 commented Jan 1, 2025

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

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants