https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=30624
--- Comment #46 from Lucas Gass <[email protected]> --- (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. _______________________________________________ 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/
