gnucash-user Digest, Vol 119, Issue 35

[Derek Atkins]

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.

> Don

> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.

-derek

-- 
       Derek Atkins, SB '93 MIT EE, SM '95 MIT Media Laboratory
       Member, MIT Student Information Processing Board  (SIPB)
       URL: http://web.mit.edu/warlord/    PP-ASEL-IA     N1NWH
       warlord at MIT.EDU                        PGP key available