gnucash-user Digest, Vol 119, Issue 35

[Colin Law]

On 14 February 2013 18:49, Derek Atkins <warlord at mit.edu> wrote:
> DonM <dm413-gc at intielectronics.com> writes:
>
>> -------- Original Message --------
>> Subject: gnucash-user Digest, Vol 119, Issue 35
>> From: gnucash-user-request at gnucash.org
>> To: gnucash-user at gnucash.org
>> Date: 2/14/2013 10:31 AM
>>
>>>> Actually, the memo field is the second line that appears below the
>>>> >description when you are using the the double line (Basic Ledger)view.
>>>> >The field that is associated to split lines is called Notes.  You can
>>>> >see that when you put the curser highlight on a split line and look at
>>>> >the title bar.  This is an important distinction, particularly if you
>>>> >are using business features such as accounts payable, but not so much
>>>> >for most of the rest of us, unless we are doing a search.
>>
>>> It is the other way round in fact (memo vs notes)
>>>
>>> Colin
>>
>> Right. So I stand by my original statement: If I am searching a bank
>> account and specify that I want to look for "memo" fields, then I am
>> inherently looking for a split (memo fields only exist in splits), and
>> I would expect to find the text.
>
> You can, but it will only search for memos on the split that is
> explicitly tied to the current account.  I.e, what you are effectively
> searching for is:
>
>   where Split.Account == ThisAccount AND Split.Memo == "memo"
>
> It sounds like what you WANT to be able to do is:
>
>   where Split.Account == ThisAccount AND
>   Split.ParentTransaction.AnySplit.Memo == "memo"
>
> Unfortunately this latter query does not exist, and would actually be
> somewhat hard to implement in the current Query format, specifically
> because "AnySplit" doesn't exist and would be hard to implement.

I think what is expected that every split in every transaction of the
account on display is searched.  I don't think that matches the query
above does it?

Colin