Hello, I am using gnucash with mysql backend.
I know how to query mysql database, to list for example all transactions for the last week: SELECT t.post_date,a.name,t.description,s.value_num FROM splits as s,transactions as t,accounts as a WHERE s.account_guid = a.guid AND s.tx_guid = t.guid AND a.account_type = 'EXPENSE' AND t.post_date >= DATE_SUB(NOW(), INTERVAL 1 WEEK) ; But I need something different: Can I list all transactions *entered* or *changed* during the last week? I mean, if I create a transaction today, regardless whether it is 2 months in the future, can I list all changes that I made to the database during given interval ? thank you _______________________________________________ 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.
