[Koha-bugs] [Bug 8991] Add a script to delete old orders

[bugzilla-daemon at bugs.koha-community.org]

http://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=8991

Melia Meggs <melia at bywatersolutions.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|Needs Signoff               |Signed Off
                 CC|                            |melia at bywatersolutions.com

--- Comment #4 from Melia Meggs <melia at bywatersolutions.com> ---
Before running the purge_orders script, I checked what orders I had.

mysql> SELECT * FROM aqorders WHERE datereceived IS NOT NULL\G;

I found 4 orders with the following datereceived:
2012-10-13
2012-10-13
2012-11-29
2012-11-30


Then I ran purge_orders.pl -until 2012-11-01

mysql> SELECT * FROM aqorders WHERE datereceived IS NOT NULL\G;

Now I found 2 orders with the following datereceived:
2012-11-29
2012-11-30


So it would appear that everything with datereceived before 2012-11-01 has been
correctly purged, and I'm signing off.

-- 
You are receiving this mail because:
You are watching all bug changes.