https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=21214
Hammat wele <hammat.w...@inlibro.com> changed: What |Removed |Added ---------------------------------------------------------------------------- Attachment #113008|0 |1 is obsolete| | --- Comment #11 from Hammat wele <hammat.w...@inlibro.com> --- Created attachment 148622 --> https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=148622&action=edit Bug 21214: cleanup_database.pl --keep-lc to dodge deletion in message_queue based on letter_code Librarians sometime worry if a certain email was sent or not to a patron (PREDUES, ODUES, etc.), and iirc, there are no way to have that information once the cleanup_database.pl has run, unless we dig back an archive of their database. This patch would let an admin choose which letters to keep in the message_queue, based on its letter_code, by passing a comma-separated list to the script. TEST PLAN: 1) Either you have already have data, or you'll want to add some new test lines in your message_queue table . INSERT INTO message_queue(borrowernumber,letter_code,message_transport_type,status,time_queued) VALUES(1,<YOUR CODE OF CHOICE>,'email','sent','2018-01-01 00:00:42'); 2) Make a backup of this table 3) Run the script patchless with the --mail 1 option 3.1) Messages older than 1 day should have been deleted 4) Put the data back in 5) Apply patch 6) Choose a letter_code you'd like to keep, and run the script with --mail 1 --keep-lc <CODE1>[,<CODE2>] 7) Messages older than 1 day that don't have the code <CODE1> [or <CODE2>] should've been deleted -- You are receiving this mail because: You are watching all bug changes. _______________________________________________ Koha-bugs mailing list Koha-bugs@lists.koha-community.org https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs website : http://www.koha-community.org/ git : http://git.koha-community.org/ bugs : http://bugs.koha-community.org/