QueryView 插件的视图玩法——统计每月阅读量

1、在文档内填入属性。如图所示：按格式填入键值（注意是中文：）；

2、

根据属性值文本排序，例如年月：202410

• //!js
  const query = async () => {
      let dv = Query.DataView(protyle, item, top);
      const SQL = `
      SELECT
    (SELECT SUBSTR(content,4, 10) 
     FROM blocks 
       WHERE content REGEXP '^年月：[0-9]+(\.[0-9]+)?$' 
       AND root_id = b.id
     LIMIT 1) AS month,
     COUNT(*) AS count
  FROM blocks b
   WHERE type = 'd'
   AND id IN (SELECT root_id
               FROM blocks
               WHERE content REGEXP '^时间：[0-9]+(\.[0-9]+)?$')
  GROUP BY month
  ORDER BY month`;
  
      let blocks = await Query.sql(SQL);
      dv.addeline(blocks.pick('month'), blocks.pick('count'), {
          title: '每月阅读量',
          xlabel: '月份',
          ylabel: '书籍数目'
      });
  
      dv.render();
  }
  
  return query();
  

3、结果如图：间接实现了模板列的查询统计

4、疑问和求助

能否按月统计阅读时间？