Hi John, I tried your recommendation. I actually tried to test all scenarios I can think of (I can't help myself). Unfortunately, it still does not produce the result I want.
I'm sharing the results and details of what I did here. Google Docs here https://docs.google.com/document/d/16-4oAiKGfULuI0GJXV73JUx6dv7aLk5mjYDAAo3FK5E/edit?usp=sharing or if you prefer PDF here https://docs.google.com/document/d/16-4oAiKGfULuI0GJXV73JUx6dv7aLk5mjYDAAo3FK5E/edit?usp=sharing Is there anything I am missing? Thanks. On Mon, Mar 9, 2020 at 11:52 AM John Ralls <jra...@ceridwen.us> wrote: > 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 <gbacar...@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 <jra...@ceridwen.us> wrote: > > > >> > >> > >>> On Mar 7, 2020, at 8:04 PM, Gio Bacareza <gbacar...@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 <jra...@ceridwen.us> wrote: > >>> > >>>> > >>>> > >>>>> On Mar 7, 2020, at 1:20 AM, Gio Bacareza <gbacar...@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@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. > > -- cheers, Gio _______________________________________________ gnucash-user mailing list gnucash-user@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.