[GNC] sql query to show all changed transactions during given time interval

[Derek Atkins]

Entered is doable (based on date entered column).  Changed... Not so much.  
There isn't a column for that.

-derek
Sent using my mobile device. Please excuse any typos.
On June 16, 2021 11:25:02 PM Fourhundred Thecat <400thecat at gmx.ch> wrote:

> 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 at 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.