Re: [GNC] future of custom reports in 3.x

2018-04-10 Thread William Jackson
> Is there some clear documentation of the SQL schema somewhere?

https://wiki.gnucash.org/wiki/SQL

https://wiki.gnucash.org/wiki/images/8/86/Gnucash_erd.png
___
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.


Re: GnuCash 3.0 Released

2018-04-02 Thread William Jackson
> MySQL and SQLite3 date storage has changed a bit. Once converted, MySQL 
> and SQLite3 database will be loadable only by GnuCash 2.6.19 and later.

Was PostgreSQL omitted from this statement accidentally, or do the
changes not apply to that database backend?
___
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.


Re: Bank reconciliation history

2017-10-31 Thread William Jackson
> Am going to look at writing some SQL to pull this out of the GNU cash database

You will be looking for the "reconcile_date" column on the "splits"
table. I use PostgreSQL and I'm curious to hear about any fancy SQL
you come up with!

Wiliam
___
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.