Hi! I’ve created a Book collection and, with Dataview, I’ve created also a table with a link to a folder containing one file for each author (where I can find all the book I have read or want to read belonging to this author). So I have a folder with the books and a folder with the authors. How can I create a table (or something similar, maybe a Kanban Board?) where I can see, for each author, the book in my folder. Hope to have explained clearly what I have in mind: sorry, English is not my mother-language as you can easily guess Thanks in advance for any help

  • dakerDraws@pawb.social
    link
    fedilink
    English
    arrow-up
    0
    ·
    1 year ago

    Do you want to do something like this?

    table without ID file.link AS "Author",
    filter(file.inlinks,(x)=>contains(x.Author,file.link) & contains(x.file.path,"Book Folder")) AS "Books"
    from "Author Folder"
    sort file.name
    

    The only thing you would need to change in this code is the Book Folder and Author Folder.

    But if you would like it to be a more visually appealing gallery, there may be some community plug ins you’ll have to try.

    • ilbradipo@feddit.itOP
      link
      fedilink
      English
      arrow-up
      1
      ·
      1 year ago

      Thank a lot! Exactly what I’m looking for! Where can I learn about the “query language” you’ve used? Can you point me also to the plugins I can try? Thanks in advance!