Martin, thanks. It helps!
Regarding documentation, does it make sense to insert in it links to a relevant parts of the source code (like you pointed me now to). So, whilst it will probably mot meet google documentation quality requirements, it will definitely help users. Unfortunately google docs, whilst being very good for real time collaboration, do not have "offline draft version" feature (like wiki), which makes it difficult to contribute and/or submit pull request. On Tuesday, December 1, 2020 at 5:38:43 AM UTC+1 [email protected] wrote: > The query code is not super well documented (nor well tested). It was > intended originally as a proof of concept and grew to become the main > interface. > I'm going to rewrite it completely in v3, with documentation. > For now you can use the source code: > > https://github.com/beancount/beancount/blob/master/beancount/query/query_env.py > > > > On Mon, Nov 30, 2020 at 7:17 PM Chary Chary <[email protected]> wrote: > >> Patrick, >> >> I am still puzzled with your example. >> >> What is this *only *function, for instance, where is it documented? >> >> >> On Monday, November 30, 2020 at 5:20:23 PM UTC+1 [email protected] >> wrote: >> >>> Hi, >>> >>> >>> this is bean-query, I just limited it to the select part, for your case >>> it would be something like >>> >>> >>> number(only("CHF", convert(sum(value(position, #"2020-12-31")), "CHF", >>> #"2020-12-31"))) WHERE account ~'Expenses' >>> >>> >>> Regards, >>> >>> Patrick >>> >>> >>> On 30.11.2020 16:02, Chary Chary wrote: >>> >>> Patrick, >>> >>> thanks for the answer, but I am afraid I do not have enough knowledge to >>> understand your answer. >>> >>> What you shave show is not a bean-query language, this looks time >>> elements of python code >>> >>> Can you in this case give me some broader and complete source of code >>> and I will try to get my head around >>> >>> Regards. >>> >>> On Sunday, November 29, 2020 at 4:58:33 PM UTC+1 [email protected] >>> wrote: >>> >>>> Hi, >>>> >>>> Do you have different currencies? Here is a (complex) example that I >>>> run to value and convert with a specific year. >>>> >>>> number(only("CHF", convert(sum(value(position, #"2020-12-31")), "CHF", >>>> #"2020-12-31"))) >>>> >>>> Let's deconstruct that from the inner parts >>>> >>>> sum(value(position, #"2020-12-31")) >>>> this sums up the value of a position (using prices from 2020-12-31) >>>> >>>> convert(..., "CHF", #"2020-12-31") >>>> convert everything to CHF with FX as of 2020-12-31 >>>> >>>> number(only("CHF", ...)) >>>> Now take only the CHF out of this (as everything was converted to CHF, >>>> this is actually only CHF)) and then take the number >>>> >>>> >>>> If you don't have different currencies or prices involved it becomes a >>>> lot simpler and you can drop those parts. >>>> >>>> >>>> Regards, >>>> >>>> Patrick >>>> >>>> >>>> On 29.11.2020 16:50, Chary Chary wrote: >>>> >>>> Hi, everybody >>>> >>>> is there a way to get a single number report with bean-query >>>> >>>> e.g. I want all Expenses for all the period in one number. >>>> >>>> The maximum I got so far is listing all expense accounts and their >>>> balance. To to get a total expenses I would have to dump it all in Excel >>>> and sum there. >>>> >>>> So, I want something like >>>> >>>> SUM(COST(position)) WHERE account ~'Expenses' >>>> >>>> But this does not work >>>> >>>> Regards. >>>> >>>> -- >>>> 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 on the web visit >>>> https://groups.google.com/d/msgid/beancount/31497363-986a-4745-a202-526236c532d8n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/beancount/31497363-986a-4745-a202-526236c532d8n%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 on the web visit >>> https://groups.google.com/d/msgid/beancount/3ca0d4b1-d0ad-4d8c-be56-01a449ec4c90n%40googlegroups.com >>> >>> <https://groups.google.com/d/msgid/beancount/3ca0d4b1-d0ad-4d8c-be56-01a449ec4c90n%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 on the web visit >> https://groups.google.com/d/msgid/beancount/5545ee62-b2fd-4f06-be60-2cd4317fc808n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/beancount/5545ee62-b2fd-4f06-be60-2cd4317fc808n%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 on the web visit https://groups.google.com/d/msgid/beancount/69a20d6d-e762-45e3-95db-94c46c155895n%40googlegroups.com.
