[GNC] Find or search all expenses in a certain account

[John Ralls]

Gio,

No surprise, that's not exactly lucid.

I just tried again with a more realistic test book. The problem is that "matches all accounts" means what it says: if you give it ten accounts then any transaction must have splits in all 10 of them to match.

Experimenting around a bit more, I find that if you start from the Accounts page and use Accounts - Matches Any Account - Foo + Bar (where Foo and Bar are accounts selected in the account list box) you get all of the transactions with a split touching either Foo or Bar. If you use All Accounts - Matches Any Account - Foo + Bar you get transactions with at least one split in each of Foo and Bar.

If you start from a register tab then the Accounts - Matches Any Account - XXX will return no transactions unless XXX is the account whose register you have focussed. Using All Accounts with a single account selected will return the transactions from that register with a split touching that one account.

So the way to get what you want is to change the selector in the upper right from "all criteria are met" to "any criteria are met" and then enter a line All Accounts - Matches Any Account - XXX for each expense account that you want to include in the result.

Regards,
John Ralls


> On Mar 8, 2020, at 8:00 PM, Gio Bacareza <gbacareza at gmail.com> wrote:
> 
> Hi John,
> 
> I also actually tried that Find > All Accounts > Choose Accounts =
> Expenses:(all children) and it's still blank.
> 
> To be honest, I find this text in the documentation really hard to
> understand:
> "The Account option performs a search where the accounts selected in the
> Choose Accounts dialog will both be searched individually for results. This
> means that a match in any of the selected accounts will either be displayed
> (matches any account) or discarded (matches no account).
> 
> The All Accounts option performs a search where accounts selected in the
> Choose Accounts dialog will only return results that match in both
> accounts."
> 
> Thanks
> 
> On Sun, Mar 8, 2020 at 12:40 PM John Ralls <jralls at ceridwen.us> wrote:
> 
>> 
>> 
>>> On Mar 7, 2020, at 8:04 PM, Gio Bacareza <gbacareza at gmail.com> wrote:
>>> 
>>> Thanks John. I'm trying to run in from the register page.
>>> 
>>> On Sun, Mar 8, 2020 at 1:52 AM John Ralls <jralls at ceridwen.us> wrote:
>>> 
>>>> 
>>>> 
>>>>> On Mar 7, 2020, at 1:20 AM, Gio Bacareza <gbacareza at gmail.com> wrote:
>>>>> 
>>>>> Hi I tried to search all expenses in a certain account by doing Find >
>>>>> Account > Matches Any Account - Selected Expense Account and ALL child
>>>>> accounts.
>>>>> 
>>>>> Result: blank
>>>>> 
>>>>> What am I doing wrong?
>>>>> 
>>>> 
>>>> Did you run Find from the Accounts page or from a register page?
>>>> 
>> 
>> When you run from a register page Find searches only that account and
>> Account in find matches the current account rather than the transfer
>> account. If I understand what you're trying to do, use  All Accounts -
>> matches all accounts - xxx where xxx means to select the accounts you want
>> to search for in the selector dialog box.
>> 
>> Regards,
>> John Ralls
>> 
>> 
>> 
>> 
>> 
> 
> -- 
> cheers,
> 
> Gio
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.