目前写过的最复杂的模板了，按文档名升序排列。
类似模板见【模板】汇总今天更新或指定日期范围的文档 · 语雀 (yuque.com)

注意：使用了updated和created字段，入围的文档至少在那个时间有创建过新块、改动过文字

上个月更新的文档

  2. .action{/* -------1.获取今年年份和上个月的月份数字------- */}
  4. .action{$this_year :=now | date "2006"} 
  5. .action{$this_month :=now | date "01"} 
  6. .action{$last_month := sub $this_month 1} 
  7. .action{/* 处理月份为两位整数，小于10，则为0x */}
  8. .action{if gt $last_month 10}
  9. .action{/* if语句内如果想要给外部的全局变量赋值，需要用=而不是:=*/}
  10. .action{$last_month = $last_month}
  11. .action{else}
  12. .action{$last_month = nospace (cat "0" $last_month)}
  13. .action{end}
  14. .action{/* -------2.判断今年是否为闰年，得到这个月的最后一天------- */}
  16. .action{/* 2.1判断闰年，相当于if year % 4 == 0 and year % 100 != 0 or year % 400 == 0 */}
  17. .action{$is_leap := any (all (empty (mod $this_year  4)) (not (empty (mod $this_year  100)))) (empty (mod $this_year  400))}
  18. .action{$MonthDict1 := dict "01" "31" "02" "28" "03" "31" "04" "30" "05" "31" "06" "30" "07" "31" "08" "31" "09" "30" "10" "31" "11" "30" "12" "31"}
  19. .action{$MonthDict2 := dict "01" "31" "02" "29" "03" "31" "04" "30" "05" "31" "06" "30" "07" "31" "08" "31" "09" "30" "10" "31" "11" "30" "12" "31"}
  20. .action{$Dicts := dict "true" $MonthDict2 "false" $MonthDict1}
  21. .action{$MonthDict := get $Dicts (toString $is_leap)}
  23. .action{/* 2.2得到这个月的最后一天 */}
  24. .action{$last_day := get $MonthDict (toString $last_month)}
  25. .action{$last_month_first :=nospace (cat $this_year "-" $last_month "-01")}
  26. .action{$last_month_last :=nospace (cat $this_year "-" $last_month "-" $last_day)}
  28. .action{/* 2.3格式化这个月的第一天和最后一天 */}
  29. .action{$from:= toDate "2006-01-02 15:04:05" (cat $last_month_first "00:00:00")}
  30. .action{$to := toDate "2006-01-02 15:04:05" (cat $last_month_last "23:59:59")}
  33. .action{/* -------3.获得上个月更新的所有笔记文档------- */}
  34. ## .action{$from | date "2006.01.02  Mon"} \~  .action{$to | date "2006.01.02  Mon"} 期间更新的笔记文档
  36. .action{$from:= $from | date "20060102150405"}
  37. .action{$to:= $to | date "20060102150405"}
  39. .action{/* 按文档名升序排列 */}
  40. .action{$blocks :=queryBlocks "SELECT * FROM blocks WHERE id in (SELECT root_id FROM blocks WHERE root_id != '?' AND (created >= '?' AND created <= '?' OR updated >= '?' AND updated <= '?') ) order by HPath LIMIT -1" .id $from $to $from $to }
  43. .action{range $v := $blocks}
  44. - [.action{$v.HPath}](siyuan://blocks/.action{$v.ID})  
  45. .action{end}

某个月更新的文档

  1. .action{/* 设置想查询的年份和月份 */}
  2. .action{$this_year := 2021} 
  3. .action{$this_month := 7} 
  6. .action{/* -------1.获取今年年份和上个月的月份数字------- */}
  8. .action{/* 处理月份为两位整数，小于10，则为0x */}
  9. .action{if gt $this_month 10}
  10. .action{/* if语句内如果想要给外部的全局变量赋值，需要用=而不是:=*/}
  11. .action{$this_month = $this_month}
  12. .action{else}
  13. .action{$this_month = nospace (cat "0" $this_month)}
  14. .action{end}
  16. .action{/* -------2.判断今年是否为闰年，得到这个月的最后一天------- */}
  18. .action{/* 2.1判断闰年，相当于if year % 4 == 0 and year % 100 != 0 or year % 400 == 0 */}
  19. .action{$is_leap := any (all (empty (mod $this_year  4)) (not (empty (mod $this_year  100)))) (empty (mod $this_year  400))}
  20. .action{$MonthDict1 := dict "01" "31" "02" "28" "03" "31" "04" "30" "05" "31" "06" "30" "07" "31" "08" "31" "09" "30" "10" "31" "11" "30" "12" "31"}
  21. .action{$MonthDict2 := dict "01" "31" "02" "29" "03" "31" "04" "30" "05" "31" "06" "30" "07" "31" "08" "31" "09" "30" "10" "31" "11" "30" "12" "31"}
  22. .action{$Dicts := dict "true" $MonthDict2 "false" $MonthDict1}
  23. .action{$MonthDict := get $Dicts (toString $is_leap)}
  25. .action{/* 2.2得到这个月的最后一天 */}
  26. .action{$last_day := get $MonthDict (toString $this_month)}
  27. .action{$this_month_first :=nospace (cat $this_year "-" $this_month "-01")}
  28. .action{$this_month_last :=nospace (cat $this_year "-" $this_month "-" $last_day)}
  30. .action{/* 2.3格式化这个月的第一天和最后一天 */}
  31. .action{$from:= toDate "2006-01-02 15:04:05" (cat $this_month_first "00:00:00")}
  32. .action{$to := toDate "2006-01-02 15:04:05" (cat $this_month_last "23:59:59")}
  35. .action{/* -------3.获得上个月更新的所有笔记文档------- */}
  36. ## .action{$from | date "2006.01.02  Mon"} \~  .action{$to | date "2006.01.02  Mon"} 期间更新的笔记文档
  38. .action{$from:= $from | date "20060102150405"}
  39. .action{$to:= $to | date "20060102150405"}
  41. .action{/* 按文档名升序排列 */}
  42. .action{$blocks :=queryBlocks "SELECT * FROM blocks WHERE id in (SELECT root_id FROM blocks WHERE root_id != '?' AND (created >= '?' AND created <= '?' OR updated >= '?' AND updated <= '?') ) order by HPath LIMIT -1" .id $from $to $from $to }
  45. .action{range $v := $blocks}
  46. - [.action{$v.HPath}](siyuan://blocks/.action{$v.ID})  
  47. .action{end}

某一范围更新的文档

  1. .action{/* 在这里更新查询的起始时间*/}
  2. .action{$from:= toDate "2006-01-02 15:04:05" "2022-03-01 00:00:00"}
  3. .action{$to := toDate "2006-01-02 15:04:05" "2022-03-31 23:59:59"}
  5. ## .action{$from | date "2006.01.02  Mon"} \~  .action{$to | date "2006.01.02  Mon"} 期间更新的笔记文档
  8. .action{$from:= $from | date "20060102150405"}
  9. .action{$to:= $to | date "20060102150405"}
  11. .action{/* 按文档名升序排列 */}
  12. .action{$blocks :=queryBlocks "SELECT * FROM blocks WHERE id in (SELECT root_id FROM blocks WHERE root_id != '?' AND (created >= '?' AND created <= '?' OR updated >= '?' AND updated <= '?') ) order by HPath LIMIT -1" .id $from $to $from $to }
  15. .action{range $v := $blocks}
  16. - [.action{$v.HPath}](siyuan://blocks/.action{$v.ID})  
  17. .action{end}