Can you help me with an example please ?
bean-query ~/beancount/personal.beancount "JOURNAL 'Expenses' FROM number >
800"didn't work for me. Greetings, Varac Excerpts from Martin Blais's message of Oktober 22, 2020 3:20 vormittags: > I think you want "number" > https://github.com/beancount/beancount/blob/v2/beancount/query/query_env.py#L1662 > > > On Tue, Oct 20, 2020 at 3:57 AM Varac <[email protected]> wrote: > >> Hi, >> >> new beancount user here, I'd like to filter a journal query by amount, >> i.e. show all transactions with an amount > X euros. >> I tried but nothing seems to work for me i.e.: >> >> "JOURNAL 'Expenses' FROM year = 2014 AND cost_number > '100'" >> ERROR: Invalid column name 'cost_number' in FROM clause context. >> >> >> Greetings, Varac >> >> -- >> 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/1603180319.e43z90u5bm.astroid%40rocinante.none >> . >> > > -- > 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/CAK21%2BhObYOfajfJ5V6kf%3DSjcwdmsEza54%3D7XkeKoGL_gBhXNjQ%40mail.gmail.com. > I think you want "number" > https://github.com/beancount/beancount/blob/v2/beancount/query/query_env.py# > L1662 > > > On Tue, Oct 20, 2020 at 3:57 AM Varac <[email protected]> wrote: > > Hi, > > new beancount user here, I'd like to filter a journal query by amount, > i.e. show all transactions with an amount > X euros. > I tried but nothing seems to work for me i.e.: > > "JOURNAL 'Expenses' FROM year = 2014 AND cost_number > '100'" > ERROR: Invalid column name 'cost_number' in FROM clause context. > > > Greetings, Varac > > -- > 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/1603180319.e43z90u5bm.astroid%40rocinante.none. > > -- > 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/ > CAK21%2BhObYOfajfJ5V6kf%3DSjcwdmsEza54%3D7XkeKoGL_gBhXNjQ%40mail.gmail.com. > -- 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/1603352777.alwuhhq818.astroid%40rocinante.none.
pgp0AXukeM0Js.pgp
Description: PGP signature
