Cannot find text or value inside a split

[Colin Law]

On 15 February 2013 00:51, John Ralls <jralls at ceridwen.us> wrote:
>
> On Feb 14, 2013, at 1:55 PM, Colin Law <clanlaw at googlemail.com> wrote:
>> ...
>> I must be missing something, Derek's query includes split.Account ==
>> ThisAccount, but we want to find matches where split.Account !=
>> ThisAccount, don't we want instead something like
>> Split.ParentTransaction.AnySplit.Account == ThisAccount AND
>> Split.Memo == "memo"
>>
>
> You're getting tied up in pseudocode.
>
> What Derek is trying to convey is "For each split whose account matches the current account, retrieve from that split's parent transaction every split and return all of those splits whose memo matches 'memo'".
>
> Split.ParentTransaction.AnySplit.Account == ThisAccount is functionally the same as Split.Account == ThisAccount. That's what Gnucash does now.

OK, got it.  Isn't AnySplit just a join between the transactions and
splits tables?

Colin