[Koha-bugs] [Bug 29457] Fee Cancellation records the wrong manager_id
bugzilla-daemon at bugs.koha-community.org
bugzilla-daemon at bugs.koha-community.org
Fri Dec 3 10:27:45 CET 2021
https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=29457
--- Comment #29 from Marcel de Rooy <m.de.rooy at rijksmuseum.nl> ---
This seems like overkill. But it worked for me without CAST warnings etc on
alphanumeric userid's :
UPDATE accountlines
LEFT JOIN borrowers ON CAST(borrowers.userid AS INT) = accountlines.manager_id
SET manager_id = borrowers.borrowernumber
WHERE manager_id IS NOT NULL AND userid RLIKE "^[0-9]+$" AND
borrowers.borrowernumber IS NOT NULL AND credit_type_code = 'CANCELLATION'
--
You are receiving this mail because:
You are watching all bug changes.
More information about the Koha-bugs
mailing list