As part of our PKM group conversation yesterday, there some people who want me to document what I’m doing for a Books Dashboard.
This metadata - which I autogenerate:
Allows to generate tables of my wishlist:
Discarded (includes the reason for stopping so I don’t repeat the mistake):
When you look at the metadata the books status and therefore which table it appears in is controlled by an emoji. That might have been a mistake, text based status might have been easier.
(Caveat Discourse is eating the
dataview at the top and bottom of the code blocks).
The dataview queries that populate the tables are:
TABLE join(rows.Author, "<br>") AS Author, join(rows.file.link, "<br>") AS Book FROM "Sources/BookNotes" WHERE status = "📥" GROUP BY Category
TABLE Author, Category FROM "Sources/BookNotes" WHERE status = "⏳"
TABLE Author, Reason FROM "Sources/BookNotes" WHERE status = "🗑️"
Someone asked for a picture of the shortcut: