统计

字数统计

笔记库统计

list without id "笔记库中共有" +length(rows) + "个页面，总计约" + round(sum(rows.file.size)/10000,0) + "万字节（" + round((sum(rows.file.size)/1048576), 2) + "MB）" group by 12345

分数大于8的书

已读

let books = dv.pages("#book")
    .where(b => b.阅读状态 == "已读完")
    .sort(b => b.结束阅读, 'desc'); // 升序
dv.paragraph("📚 已读完数量：" + books.length);
dv.table(
["书名","添加时间", "结束阅读","阅读天数"],
 books.map(b => [
 `[${b.title}](${b.file.path})`,
 b.添加时间,
 
 b.结束阅读,
    (b.结束阅读 && b.开始阅读)
      ? moment(b.结束阅读.toString()).diff(moment(b.开始阅读.toString()), "days") + " 天"
      : "未记录"
 ]))
 ;
 

书库

let books = dv.pages("#book")
    .sort(b => b.开始阅读
    , 'desc'); // 升序
dv.paragraph("📚 所有书籍：" + books.length);
dv.table(["书名", "结束阅读"], books.map(b => [`[${b.title}](${b.file.path})`, b.结束阅读]));
 

movie

let movies = dv.pages("#movies")
    .where(b => b.state == "已看")
    .sort(b => b.添加时间, 'desc'); // 升序
dv.paragraph(" 已看数量：" + movies.length);
dv.table(
["title","originalTitle", "添加时间","score","myRating"],
 movies.map(b => [
 `[${b.title}](${b.file.path})`,
 b.originalTitle,
 b.添加时间,
 b.score,
 b.myRating]))
 
 ;