Open/close/clear was made to implement reporting on a bounded period, e.g., a single financial year.
On Wed, Mar 25, 2026, 03:27 Justus Pendleton <[email protected]> wrote: > That sounds right to me. > > Though to be honest, I've never really understood the use cases for > open/close/clear and I don't think I've ever used them personally. > > On Tuesday, March 24, 2026 at 2:11:36 AM UTC+10:30 Chary Ev2geny wrote: > >> Dear all, >> >> Coming back to this question about the traditional vs #table syntax for >> the SELECT query >> >> On Tuesday, May 6, 2025 at 4:12:28 PM UTC+2 [email protected] wrote: >> >> >> > In this mode all the additional perks like JOURNAL, OPEN ON, CLOSE ON, >> > BALANCES do not seem to be available. >> >> Unless there is a bug somewhere, OPEN ON and CLOSE ON are supported also >> when using the new syntax (although they do no always make sense). >> JOURNAL and BALANCES can be thought as macros that expand to a regular >> SELECT query. What do you mean when you write that the new mode does not >> support them? >> >> >> >> If I check at the *beanquery/parser/bql.ebnf >> <https://github.com/beancount/beanquery/blob/master/beanquery/parser/bql.ebnf>* >> language definition file >> >> >> Then for me it looks, that it is designed so, that OPEN ON, CLOSE ON and >> CLEAR only work in the traditional (not #table) format >> >> >> select::Select >> = 'SELECT' ['DISTINCT' distinct:`True`] targets:(','.{ target }+ | >> asterisk) >> ['FROM' from_clause:(_table | subselect | from)] >> ['WHERE' where_clause:expression] >> ['GROUP' 'BY' group_by:groupby] >> ['ORDER' 'BY' order_by:','.{order}+] >> ['PIVOT' 'BY' pivot_by:pivotby] >> ['LIMIT' limit:integer] >> ; >> >> subselect >> = '(' @:select ')' >> ; >> >> from::From >> = >> | 'OPEN' ~ 'ON' open:date ['CLOSE' ('ON' close:date | {} >> close:`True`)] ['CLEAR' clear:`True`] >> | 'CLOSE' ~ ('ON' close:date | {} close:`True`) ['CLEAR' >> clear:`True`] >> | 'CLEAR' ~ clear:`True` >> | expression:expression ['OPEN' 'ON' open:date] ['CLOSE' ('ON' >> close:date | {} close:`True`)] ['CLEAR' clear:`True`] >> ; >> >> _table::Table >> = >> | name:/#([a-zA-Z_][a-zA-Z0-9_]*)?/ >> | name:quoted_identifier >> ; >> >> Or am I missing something? >> >> > -- > 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 [email protected]. > To view this discussion visit > https://groups.google.com/d/msgid/beancount/870f81fb-0099-4a3e-9339-c151dc1c0b4fn%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/870f81fb-0099-4a3e-9339-c151dc1c0b4fn%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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 [email protected]. To view this discussion visit https://groups.google.com/d/msgid/beancount/CAK21%2BhP6_ub%2Bwsdt0x8OsxiJwgNcEvcxY04S_DNhhFUOLL%3DasQ%40mail.gmail.com.
