Reading Dashboard

📚 Currently Reading

TABLE 
    author,
    started as "Started",
    rating as "Rating"
FROM "03-Resources"
WHERE contains(tags, "book") AND !contains(tags, "completed")
SORT started DESC

✅ Recently Completed Books

TABLE 
    author,
    finished as "Finished",
    rating as "Rating"
FROM "03-Resources"
WHERE contains(tags, "book") AND contains(tags, "completed")
SORT finished DESC
LIMIT 10

🌟 Highest Rated Books

TABLE 
    author,
    finished as "Finished",
    rating as "Rating"
FROM "03-Resources"
WHERE contains(tags, "book") AND rating
SORT rating DESC
LIMIT 10

📊 Reading Stats

TABLE 
    length(rows) as "Total"
FROM "03-Resources"
WHERE contains(tags, "book")
GROUP BY dateformat(date(finished), "yyyy") as Year
SORT Year DESC

📑 Books by Author

TABLE
    rows.file.link as "Books"
FROM "03-Resources"
WHERE contains(tags, "book") AND author
GROUP BY author
SORT length(rows) DESC

📝 Reading Notes to Process

LIST
FROM "00-Inbox"
WHERE contains(tags, "book") OR contains(tags, "reading")
SORT file.mtime DESC