https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30624 --- Comment #46 from Lucas Gass <lucas@bywatersolutions.com> --- (In reply to Lucas Gass from comment #45)
2) Database update
UPDATE borrowers SET flags = flags + (1<<29) WHERE flags & 4
Can you explain that one to me? I have written stuff like that before, but it's not coming back to me right now. I had expected something like "where flags != 0 and IS NOT NULL"?
Because I want to set the new loggedinlibrary permission for patrons that have the staff access permission when IndependentBranches is turned on.
Now that I think about it what you say would work too "WHERE flags != 0 and IS NOT NULL".
Happy to change it if you'd like!
Nick brought up a good point. We should specifically check for the staff access (catalogue) permission. Some API accounts may have other permissions but not staff access. -- You are receiving this mail because: You are watching all bug changes.