Difference between revisions of "gnucash mysql invoice query"

From thelinuxwiki
Jump to: navigation, search
(CLI queries for gnucash invoice data)
Line 3: Line 3:
  
 
'''get invoice guid'''
 
'''get invoice guid'''
  mysql> '''SELECT guid FROM gnucash_netsolve_2013.invoices WHERE id = "2013018";'''
+
  mysql> '''SELECT guid FROM gnucash_database.invoices WHERE id = "2013018";'''
 
  +----------------------------------+
 
  +----------------------------------+
 
  | guid                            |
 
  | guid                            |

Revision as of 13:52, 24 May 2013

CLI queries for gnucash invoice data

get invoice guid

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