https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=41087

--- Comment #4 from Martin Renvoize (ashimema) 
<[email protected]> ---
Created attachment 208008
  -->
https://bugs.koha-community.org/bugzilla3/attachment.cgi?id=208008&action=edit
Bug 41087: Add resolved columns to edifact_errors

Rolling an EDIFACT message back keeps its processing errors so it stays
visible why the message was rolled back: they are marked resolved
instead of being deleted.

This adds four nullable columns to edifact_errors:
 - resolved_on: when the error was resolved, NULL while it is open
 - resolved_by_id: the staff member who resolved it (FK to borrowers)
 - resolution: how it was resolved (rolledback, or dismissed later)
 - resolution_note: the optional reason given

Test plan:
1. Apply the patch and run updatedatabase.pl
2. Check the new columns and the emfk_resolved_by foreign key exist:
   SHOW CREATE TABLE edifact_errors;
3. Run updatedatabase.pl again and confirm it does not fail

Co-Authored-By: Claude Sonnet 5.5 <[email protected]>

-- 
You are receiving this mail because:
You are watching all bug changes.
_______________________________________________
Koha-bugs mailing list -- [email protected]
To unsubscribe send an email to [email protected]
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to