If you use joins on the guid values to the parents then you should be able to get them directly using the appropriate queries.
Colin On 11 October 2017 at 14:31, Joseph Hesse <joehe...@gmail.com> wrote: > Here is an example of what I am trying to do. My expenses in gnucash have > items that look like: > > Expenses > Auto > Gas > Service > > When I look in the mysql accounts table I can find the record containing > Service but no easy way to find Expenses:Auto:Service. The record containing > Service in the accounts table has the item parent_guid so I could use that > to locate the parent classification of Service, which is Auto. I can repeat > the process until I get a complete description of the account. > > My questions is: Is there sophisticated query where I can add a column to > the accounts table containing the full name instead of just the name? > > I know I can do what I want in a programming language like PHP or C++ but I > want to know if there is something easier. > > The reason for my questions is I am creating a custom expense report by > joining the accounts, splits and transactions table and I want the expense > name to have a full path description. > > Thank you, > Joe > > _______________________________________________ > gnucash-user mailing list > gnucash-user@gnucash.org > https://lists.gnucash.org/mailman/listinfo/gnucash-user > ----- > Please remember to CC this list on all your replies. > You can do this by using Reply-To-List or Reply-All. _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.