Signin Signup

Feature request: Filtering in Embedded Database

Hi there,

Is there a way to filter rows in an embedded block of the database?

Example

For example, if we have the following tables, how can I have an embedded view of books only written by Liu Cixin?

If I try to embed the Books database, I see all books, but I only want the last 2 books

How can I achieve this result? (for 100+ authors)

Thanks and regards,

Jeremy

3 Operate

vinitrinh updated this article at 2024-05-23 19:15:42

vinitrinh updated this article at 2024-05-23 18:58:43

vinitrinh updated this article at 2024-05-23 18:58:07

3 Operate

4 Reply

198 29 7 34 126

4 Reply

Feature request: Filtering in Embedded Database

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

zxhd86 • 2 months

this.
vinitrinh • 2 months
PRO Author

Yes, of course I see the filter feature.

What if there are 100 authors, and you'd like (1) duplicate 100+ tables for 100+ authors, (2) without affecting the original table?
vinitrinh • 2 months
PRO Author

Sorry, I can see how my request is badly phrased.

Allow me to start a new thread with a better example.
zxhd86 • 2 months
You only need to use two feature:
1. Directly copy the database. Currently, the default copying of the database is shallow copying, which means it points to the same data source.
2. Create a new view and apply filtering within this new view.
For database, you don't need to use the embedded block feature.

vinitrinh