https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=23673 Bug ID: 23673 Summary: Separate time sent from time created in message_queue table Change sponsored?: --- Product: Koha Version: master Hardware: All OS: All Status: NEW Severity: enhancement Priority: P5 - low Component: Notices Assignee: koha-bugs@lists.koha-community.org Reporter: agustinmoyano@theke.io QA Contact: testopia@bugs.koha-community.org Problem: Currently in the message_queue table the only time/date field in the message_queue table is "time_queued". This is set when the message is created and then updated when the message is sent. Additionally, the time_queued data is displayed on the notices tab in a patron's account in a column simply called "Time." Solution: We need to create separate fields for the time a message is created and for the time the message is sent. The time_queued will be populated when added to the message queue table. Populate the time_sent field with the time the message was sent and do not modify time_queued field. Then, for the purposes of helping staff answer questions about notices for patrons, we need to rename the "Time" column on the patron's notices tab to "Time sent" and add a separate column for "Time created". -- You are receiving this mail because: You are the assignee for the bug. You are watching all bug changes.