[Koha-bugs] [Bug 30624] Add a permission to control the ability to change the logged in library

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Tue Feb 28 18:32:41 CET 2023


https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30624

--- Comment #45 from Lucas Gass <lucas at bywatersolutions.com> ---
> 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!

-- 
You are receiving this mail because:
You are watching all bug changes.


More information about the Koha-bugs mailing list