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.grah...@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.grah...@herts.ac.uk > > > > _______________________________________________ > Koha-devel mailing list > Koha-devel@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
_______________________________________________ Koha-devel mailing list Koha-devel@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/
