#3066 Daysheets doesn't show the 'c' status

[Hagir]

The 'c' status (lower case) is one of the customizable appointment statuses under Oscar. When printing the daysheet (Report>All Appointments), the appointment with these statuses don't get pulled.

The cause is that reportdaysheet.jsp runs queries that are not case sensitive to exclude the cancelled appointments 'C'. "BINARY" condition must be added to the query to make it case sensitive following the template:
SELECT * FROM appointment WHERE BINARY status != 'C'

[Nick]

https://source.oscartools.org:8080/#/c/9053/

[Nick]

https://source.oscartools.org:8080/#/c/9053/

For the master

[Hagir]

This does not solve the problem. Adding UPPER function just capitalizes the status and it ends up being considered as cancelled. i.e. I enter appointment with status "c" it gets capitalized "C" then compared to cancelled status "C" and it matches for cancelled while it isn't.

This is simply fixed with a binary clause, and not upper.

[Hagir]

R:12.1: https://source.oscartools.org:8080/#/c/10878/
master: https://source.oscartools.org:8080/#/c/10879/

[SBek]

Retested Master (build #2190) -> resolved
R12.1 commit: https://source.oscartools.org:8080/#/c/10878/ -> still awaiting code review

[SBek]

Re-tested R12.1 (build #440) -> issue has been resolved.