[Koha-bugs] [Bug 23673] New: Separate time sent from time created in message_queue table

[bugzilla-daemon at bugs.koha-community.org]

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 at lists.koha-community.org
          Reporter: agustinmoyano at theke.io
        QA Contact: testopia at 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.