Querying only open accounts

[joshua...@gmail.com]

Hi all, here is my query stands:

SELECT account, sum(position) WHERE account ~ 'Assets:Bank' GROUP BY 1 ORDER BY 1

Basically just querying accounts in my "Bank" account. However, this query is pulling accounts that have been closed in the past, and I no longer want them showing up in my reports (they have a zero balance). Is there some attribute/property that I can query against to check the status of an account (open/closed)?

[Martin Blais]

Hi Joshua,

Have you tried the FROM OPEN ON <date> CLOSE ON <date> syntax?

--
You received this message because you are subscribed to the Google Groups "Beancount" group.
To unsubscribe from this group and stop receiving emails from it, send an email to beancount+unsubscribe@googlegroups.com.
To post to this group, send email to bean...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/148e748a-7563-473c-95fd-1d360ca7d9e0%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.