View source for gnucash mysql invoice query


== CLI queries for gnucash invoice data ==

'''get invoice guid'''
 mysql> '''SELECT guid FROM gnucash_netsolve_2013.invoices WHERE id = "2013018";'''
 +----------------------------------+
 | guid                             |
 +----------------------------------+
 | f32b43b6da2b19e4e9e838d30ffc1edb |
 +----------------------------------+
 1 row in set (0.00 sec)