Query to get transactions involving some account?

2021-10-10 Thread Juan Antonio Navarro Pérez
I would like to write a query that matches all postings from transactions that involve a particular account. For example something like: SELECT date, account, position FROM account ~ "Assets:Foo" Where I want to see not just postings for "Assets:Foo" (as WHERE account ~ "Assets:Foo" would do)

Re: Query to get transactions involving some account?

2021-10-10 Thread Martin Blais
Look for the HAS_ACCOUNT() function if I recall correctly On Sun, Oct 10, 2021, 04:49 Juan Antonio Navarro Pérez < juannavarrope...@gmail.com> wrote: > I would like to write a query that matches all postings from transactions > that involve a particular account. For example something like: > >

Re: Query to get transactions involving some account?

2021-10-10 Thread Juan Antonio Navarro Pérez
Fantastic! That works, thanks! On Sunday, 10 October 2021 at 13:33:17 UTC+1 bl...@furius.ca wrote: > Look for the HAS_ACCOUNT() function if I recall correctly > > On Sun, Oct 10, 2021, 04:49 Juan Antonio Navarro Pérez < > juannava...@gmail.com> wrote: > >> I would like to write a query that match