On Wed, Apr 3, 2019 at 9:39 PM g40matt <[email protected]> wrote: > THANK YOU for creating this amazing tool. I just converted a 14000 > transaction quicken file into Beancount and Fava, and i'm not looking > back. >
Really glad it's working for you. Sometimes I'm wondering how many users we have. One ask: Is there any chance the HAVING... clause can be implemented in > BQL? I'd love to give it a try but it's well above my skill level :) > The future of this SQL implementation is limited. I'd like to factor it out to its own project (with an expanded scope), but with enough customizations it could replace this one for Beancount. It's probably not hard to do, but perhaps beyond the ease and speed of adding a new function quickly in 5-10 minutes. Note that the HAVING clause is already parsed: https://bitbucket.org/blais/beancount/src/fa1edde3bcd02a277fac193f460a39c9a1461161/beancount/query/query_parser.py#lines-114 https://bitbucket.org/blais/beancount/src/fa1edde3bcd02a277fac193f460a39c9a1461161/beancount/query/query_parser.py#lines-450 It's just not implemented in the execution: https://bitbucket.org/blais/beancount/src/fa1edde3bcd02a277fac193f460a39c9a1461161/beancount/query/query_compile.py#lines-587 My use case is that I'd like to filter on an aggregate condition (for > example, don't show a row if the account balance is zero or if the payee is > zero). > > Thanks again and looking forward to where beancount and fava go in the > future! > > -- > 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 post to this group, send email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/beancount/f1449e6a-c479-41ce-a33d-21131f31fb1a%40googlegroups.com > <https://groups.google.com/d/msgid/beancount/f1449e6a-c479-41ce-a33d-21131f31fb1a%40googlegroups.com?utm_medium=email&utm_source=footer> > . > For more options, visit https://groups.google.com/d/optout. > -- 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 post to this group, send email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/beancount/CAK21%2BhNKzJZXegkMsnS1UASkHr4Nx4RQJQbYihnRynRCH8VPbQ%40mail.gmail.com. For more options, visit https://groups.google.com/d/optout.
