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?

image.png


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

image.png

image.png


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

image.png


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

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

      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.

      图片.png

      For database, you don't need to use the embedded block feature.

    • MiscReply
    • vinitrinh
      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?

    • zxhd86

      图片.png

      this.

    • vinitrinh
      PRO Author

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

      Allow me to start a new thread with a better example.