Hey, another thing: how do I access inventories in the filter (WHERE) part of my queries? I've looked at the help provided from within the interactive query command line and there seems to be a bunch of simple functions that take an inventory as an input but I can't seem to find the relevant column. It keeps telling me "Invalid column name 'inventory' in WHERE clause context" and I can't access my own columns or use sum within the filter part.
You can find the example ledger file I'm experimenting with here <https://pastebin.com/LXYZ1Z05>. The query I'm running is "SELECT account, cost_date as date, sum(position) as position, cost(sum(position)) as cost, cost_number as num WHERE currency != 'EUR' GROUP BY account, currency, cost_date, cost_number". I'm trying to filter out rows which have no inventory. Thanks again! On Friday, 27 May 2022 at 02:05:32 UTC+2 [email protected] wrote: > On 26/05/2022 23:07, Philippe Dumonet wrote: > > That is exactly what I was looking for! I did not know about cost_date. > > Also thanks for the tip on #'dd-mm-yyyy' I'll keep that in mind. > > > > Looking back at the docs and guide I don't think cost_date is really > > documented there, besides digging through the code is there a reference > > I can refer to in the future? > > The documentation does not cover everything, yet. In the bean-query > shell, the 'help targets' command lists all columns in the BQL data > model and all defined functions. > > The 'help' command lists all the available help "topics". > > Cheers, > Dan > -- 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/da6c7813-dae7-4d61-af0b-109e39b1a64bn%40googlegroups.com.
