Bug 28400

Summary: Add response_message column to message_queue table
Product: Koha Reporter: Johanna Räisä <johanna.raisa>
Component: NoticesAssignee: 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
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.
Comment 1 Johanna Räisä 2021-08-09 07:22:51 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.
Comment 2 Johanna Räisä 2024-07-29 05:36:44 UTC
Updated the title, since this can be used for all the interfaces to save a response.
Comment 3 Johanna Räisä 2024-07-29 09:17:08 UTC
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
Comment 4 Johanna Räisä 2024-07-29 09:20:27 UTC
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
Comment 5 Johanna Räisä 2024-07-29 11:18:03 UTC
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
Comment 6 David Nind 2025-01-25 21:26:08 UTC
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>
Comment 7 David Nind 2025-01-25 21:33:56 UTC
Testing notes (using KTD):
1. SQl to show the columns for a table: DESCRIBE message_queue;
Comment 8 Johanna Räisä 2025-04-17 07:09:06 UTC
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
Comment 9 Lin Wei 2025-05-12 21:17:46 UTC
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>