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: Needs Signoff --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low    
Version: Main   
Hardware: All   
OS: All   
Change sponsored?: Sponsored Patch complexity: ---
Documentation contact: Documentation submission:
Text to go in the release notes:
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

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