`FINDFIRST` and `other_accounts` are useful for this.
```
SELECT *
WHERE account ~ "Assets:Banks:Checking"
AND STR(FINDFIRST('Liabilities:CreditCard.*', other_accounts)) != 'None'
```
On Thursday, July 3, 2025 at 8:58:14 AM UTC-7 [email protected] wrote:
> I'd like to list all transfers between two accounts. For example, to
> estimate monthly credit card payments.
>
> I've tried,
>
> bean-query bc.bean "SELECT date, payee, narration WHERE account ~
> 'Assets:foo:bar' AND account ~ 'Liabilities:foo:baz'"
>
> But it returns nothing (because account is one thing, and cannot be an AND
> of two things). Can someone help me with this query? I tried ChatGPT and it
> was not helpful.
>
> Thanks,
>
> -k.
>
--
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 visit
https://groups.google.com/d/msgid/beancount/67edd3a9-c57b-4ced-b047-25f2958e9cd2n%40googlegroups.com.
