HAVING... clause

[g40matt]

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. 

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 :) 

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!

[Martin Blais]

On Wed, Apr 3, 2019 at 9:39 PM g40matt <tod...@gmail.com> 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 beancount+...@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/f1449e6a-c479-41ce-a33d-21131f31fb1a%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.