Summary: | Add response_message column to message_queue table | ||
---|---|---|---|
Product: | Koha | Reporter: | Johanna Räisä <johanna.raisa> |
Component: | Notices | Assignee: | Johanna Räisä <johanna.raisa> |
Status: | Signed Off --- | QA Contact: | Testopia <testopia> |
Severity: | enhancement | ||
Priority: | P5 - low | CC: | david |
Version: | Main | ||
Hardware: | All | ||
OS: | All | ||
GIT URL: | Change sponsored?: | Sponsored | |
Patch complexity: | --- | Documentation contact: | |
Documentation submission: | Text to go in the release notes: |
This enhancement adds a 'response_message' field to the 'message_queue' table. This can be used to save the message response. For example, some SMS providers give an ID in the response body that could be used to track the message status - this change adds a field where this information can be saved.
|
|
Version(s) released in: | Circulation function: | ||
Attachments: |
Bug 24800: Add response_message column to message_queue table
Bug 28400: Add response_message column to message_queue table Bug 28400: Add response_message column to message_queue table Bug 28400: Add response_message column to message_queue table Bug 28400: Add response_message column to message_queue table Bug 28400: Add response_message column to message_queue table |
Description
Johanna Räisä
2021-05-20 11:37:33 UTC
(In reply to Johanna Räisä from comment #0) > Some SMS providers give an id in response body which you can use to track > message status. Now message_queue table doesn't have any field where this > could be put. Probably saving the whole response body is the best thing to do since there can be more useful data than just id. Updated the title, since this can be used for all the interfaces to save a response. Created attachment 169812 [details] [review] Bug 24800: Add response_message column to message_queue table Test Plan: 1) Run the updatedatabase.pl script 2) Run update_dbix_class_files.pl 3) Check the message_queue table for the new column Sponsored-by: Koha-Suomi Oy Created attachment 169813 [details] [review] Bug 28400: Add response_message column to message_queue table Test Plan: 1) Run the updatedatabase.pl script 2) Run update_dbix_class_files.pl 3) Check the message_queue table for the new column Sponsored-by: Koha-Suomi Oy Created attachment 169821 [details] [review] Bug 28400: Add response_message column to message_queue table Test Plan: 1) Run the updatedatabase.pl script 2) Run update_dbix_class_files.pl 3) Check the message_queue table for the new column Sponsored-by: Koha-Suomi Oy Created attachment 177147 [details] [review] Bug 28400: Add response_message column to message_queue table Test Plan: 1) Run the updatedatabase.pl script 2) Run update_dbix_class_files.pl 3) Check the message_queue table for the new column Sponsored-by: Koha-Suomi Oy Signed-off-by: David Nind <david@davidnind.com> Testing notes (using KTD): 1. SQl to show the columns for a table: DESCRIBE message_queue; Created attachment 181051 [details] [review] Bug 28400: Add response_message column to message_queue table Test Plan: 1) Run the updatedatabase.pl script 2) Run update_dbix_class_files.pl 3) Check the message_queue table for the new column Sponsored-by: Koha-Suomi Oy Created attachment 182314 [details] [review] Bug 28400: Add response_message column to message_queue table Test Plan: 1) Run the updatedatabase.pl script 2) Run update_dbix_class_files.pl 3) Check the message_queue table for the new column Sponsored-by: Koha-Suomi Oy Signed-off-by: Lin Wei Li <lin-wei.li@inLibro.com> |