Question on mysql "account" table

Colin Law clanlaw at gmail.com
Wed Oct 11 09:49:47 EDT 2017


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 <joehesse at 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 at 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.


More information about the gnucash-user mailing list