Difference between revisions of "gnucash mysql invoice query"

Revision as of 13:50, 24 May 2013

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)