User Tools

Site Tools


Sidebar

Writing /opt/bitnami/dokuwiki/data/meta/git/delete-tag.meta failed
Unable to save metadata file. Hint: disk full; file permissions; safe_mode setting.

Go Back

Contact
Recent Changes
Sitemap
beancount:save_query

在 Beancount 中保存 Query

1970-01-01 query "收支明细" "
SELECT
  year, month, account, sum(number) as Total, currency, payee, narration
FROM
    year >= 2011
WHERE
    account ~ 'Expenses' OR
    account ~ 'Income'
GROUP BY year, month, account, currency, payee, narration
ORDER BY year, month, currency, Account DESC
FLATTEN
"

1970-01-01 query "每月收支" "
SELECT
  year, month, root(account, 1) as account, sum(number) as Total, currency
FROM
    year >= 2011
WHERE
    account ~ 'Expenses' OR
    account ~ 'Income'
GROUP BY year, month, account, currency
ORDER BY year, month, account DESC
FLATTEN
"

在 Fava 的侧边栏里可以看到定义好的 Query 。

beancount/save_query.txt · Last modified: 2020/04/13 12:41 by whtsky