This note collects all notes where the in property says Books.
Books
Books sorted by Ratings & YearXP
TABLE WITHOUT ID year as Year, "" as Cover, file.link as Title, join(list(by)) as Author, yearXP as YearXP, rating as RatingWHERE contains(in,this.file.link) and !contains(file.name, "Template")SORT rating desc, year asc
Extra
These are “works in progress” but they should give you some ideas for your own book groups and bookshelves.
Books by Type, Category, Group
For those wondering how to take advantage of all those properties that book notes have, here is an example. Remember, just because you can, doesn’t mean you should.
TABLE WITHOUT ID year as Year, file.link as Title, bookCategory as Category, join(list(bookGroup)) as Group, join(list(bookLCSH)) as LCSH, bookType as TypeWHERE contains(in,this.file.link) and !contains(file.name, "Template")SORT bookCategory, desc, year desc
Books by Status as "Reading"
TABLE WITHOUT ID year as Year, "" as Cover, file.link as Title, bookCategory as Category, bookType as TypeWHERE contains(in,this.file.link) and bookStatus = "reading" and !contains(file.name, "Template")SORT bookCategory, desc, year desc