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

--- Comment #45 from Lucas Gass <[email protected]> ---
> 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.
_______________________________________________
Koha-bugs mailing list
[email protected]
https://lists.koha-community.org/cgi-bin/mailman/listinfo/koha-bugs
website : http://www.koha-community.org/
git : http://git.koha-community.org/
bugs : http://bugs.koha-community.org/

Reply via email to