[Koha-devel] Status values in message_queue table

[Michael Hafen]

I'm looking at kohastructure.sql on master, and the status column of the
message_queue table seems to also allow a 'deleted' value.

On Mon, Oct 17, 2016 at 9:13 AM, Graham, Stephen <s.graham4 at herts.ac.uk>
wrote:

> Hi All – doing:
>
>
>
> select status from message_queue group by status
>
>
>
> gives me 3 values:
>
>
>
> sent
>
> pending
>
> failed
>
>
>
> Are these 3 values the only value “allowed” in this field? Or, putting it
> another way, if messages are added to the table with a different status
> value would it cause problems in Koha?
>
>
>
> The reason I’m asking is: as soon a book with a reservation is returned on
> our selfcheck machines an email is added to the message_queue table with
> the status of pending.  A lot can happen to this book before it actually
> gets on the reserve shelf, and may never actually get to the reserve
> shelf.  If the book does go missing, gets hidden etc, the user with the
> reservation still gets an email telling them that the book is ready to
> collect (when it’s not). To avoid this we are wondering if could stop this
> email from being sent (we only send out email notices once a day). We could
> delete the email from the message_queue table – I don’t really like
> deleting stuff – or we could change the status. I guess I could change to
> “failed”, but “cancelled”  sounds better.  I thinking of writing a bit of
> code to allow library staff to do this easily from the staff client – could
> I change the status to “cancelled” or is it better to stay with one of the
> original three?
>
>
>
> Cheers, Stephen
>
>
>
> Stephen Graham
>
> Library Technology Consultant
>
> Academic Resources
>
> Library and Computing Services
> University of Hertfordshire
> Hatfield  AL10 9AB
> UK
>
> Tel. 01707 286111 Ext: 77751
>
> Email s.graham4 at herts.ac.uk
>
>
>
> _______________________________________________
> Koha-devel mailing list
> Koha-devel at lists.koha-community.org
> http://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-devel
> website : http://www.koha-community.org/
> git : http://git.koha-community.org/
> bugs : http://bugs.koha-community.org/
>



-- 
Michael Hafen
Washington County School District Technology Department
Systems Analyst
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.koha-community.org/pipermail/koha-devel/attachments/20161017/22a35a71/attachment.html>