[Koha] New SQL Report - Patron Permissions

[BRANNON, CHRISTOPHER]

Cab, thanks for the comment on the SQL.  I am glad to have a report that will help me keep an eye on permissions.

FYI, I made a couple tweaks and added a second report that allows you to watch certain permissions (Permissions Check).  While I was working on it, I found that the tools sub column wouldn't display all flags if most of them were turned on.  Must be a limit in characters in each column.  So I divided the tools column in two.  I also found that the superlibrarian flag wasn't accurate when other flags were set.  I fixed both issues in both SQL.

___________________________
Christopher Brannon
IT Coordinator

Coeur d'Alene Public Library
702 E Front Ave
Coeur d'Alene, ID 83814
(208)769-2315 Ext. 456
cbrannon at cdalibrary.org
www.cdalibrary.org 

+ peanut gallery commentary -- Whoa. Will have to spend some time
learning from this lovely SQL ...

Cheers,

Cab Vinton
Sanbornton PL
Sanbornton, NH