SQL functions not documented but by their source:
https://bitbucket.org/blais/beancount/src/fa1edde3bcd02a277fac193f460a39c9a1461161/beancount/query/query_env.py#lines-873
plugin "beancount.plugins.auto"
2019-04-10 * ""
category: "1"
Assets:Checking 10 USD
Liabilities:Loan
2019-04-11 * ""
category: "2"
Assets:Checking 11 USD
Liabilities:Loan
2019-04-12 * ""
category: "1"
Assets:Checking 13 USD
Liabilities:Loan
2019-04-13 * ""
category: "2"
Assets:Checking 14 USD
Liabilities:Loan
2019-04-14 * ""
category: "3"
Assets:Checking 15 USD
Liabilities:Loan
2019-05-01 query "test" "select entry_meta('category'), sum(position) where
account ~ 'Checking' group by 1"
e sum_po
- ------
1 23 USD
2 25 USD
3 15 USD
On Sun, Apr 14, 2019 at 11:20 AM TRS-80 <[email protected]>
wrote:
> I ended up figuring it out, in a roundabout way. I'll try and remember to
> post the solution later for posterity, but basically I got it close to what
> I needed using bean-query, and then piped the output of that to awk where I
> summed the column.
>
> In my case, I needed something that could be scripted. And this did the
> job.
>
> I'm new to awk but there are tons of cool things you can do with it,
> especially with structured data.
>
> I would still like an answer on whether this is supposed to be supported
> or not, because I have searched and searched but maybe I missed it or I
> dunno what, but I sure as hell haven't been able to figure it out yet
> (strictly within Beancount tools).
>
> TRS-80
>
> On April 14, 2019 1:19:35 AM EDT, TRS-80 <
> [email protected]> wrote:
>>
>> Hello Gang,
>>
>> I have been trying every way I can think of, read all the docs, and
>> searched everything I could find on the internet, and still no joy...
>>
>> Any help would be greatly appreciated...
>>
>> Or is this not supported?
>>
>> TRS-80
>>
>> --
> 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/82AB61E5-003C-4203-AFD7-DD21A3903283%40isnotmyreal.name
> <https://groups.google.com/d/msgid/beancount/82AB61E5-003C-4203-AFD7-DD21A3903283%40isnotmyreal.name?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%2BhPCztsRKvzAr032ubx2vvf7iRZ9EroYiieGe62AbpeM_g%40mail.gmail.com.
For more options, visit https://groups.google.com/d/optout.
