Mistj's Digital Garden

Appearance

weread

2024在读 ​

dataview
table without 
id ("![](" + cover + ")") as cover ,
file.link as Title,
readingTime, 
dateformat(readingDate,"yyyy-MM-dd") 
from "读书/微信读书"  
where cover != null and readingStatus = "在读" and lastReadDate.year = 2024
table without 
id ("![](" + cover + ")") as cover ,
file.link as Title,
readingTime, 
dateformat(readingDate,"yyyy-MM-dd") 
from "读书/微信读书"  
where cover != null and readingStatus = "在读" and lastReadDate.year = 2024

2024已读 ​

dataview
table without id ("![](" + cover + ")") as cover,  file.link as Title, author as Author, "笔记：" + noteCount as NoteCount, dateformat(finishedDate,"yyyy-MM-dd") AS finishedDate , readingTime  
from "读书/微信读书"  where cover != null and readingStatus = "读完"  and finishedDate.year = 2024   
SORT finishedDate DESC
table without id ("![](" + cover + ")") as cover,  file.link as Title, author as Author, "笔记：" + noteCount as NoteCount, dateformat(finishedDate,"yyyy-MM-dd") AS finishedDate , readingTime  
from "读书/微信读书"  where cover != null and readingStatus = "读完"  and finishedDate.year = 2024   
SORT finishedDate DESC

全部已读 ​

dataview
table without id ("![](" + cover + ")") as Cover ,file.link as Title, author as Author, "笔记：" + noteCount as NoteCount, dateformat(finishedDate,"yyyy-MM-dd") as FinishedDate   
from "读书/微信读书"  where cover != null and readingStatus = "读完"  and finishedDate.year < 2024  
sort finishedDate DESC
table without id ("![](" + cover + ")") as Cover ,file.link as Title, author as Author, "笔记：" + noteCount as NoteCount, dateformat(finishedDate,"yyyy-MM-dd") as FinishedDate   
from "读书/微信读书"  where cover != null and readingStatus = "读完"  and finishedDate.year < 2024  
sort finishedDate DESC