[Koha-bugs] [Bug 35915] Add URL encoding to status tabs in purchase suggestions management

bugzilla-daemon at bugs.koha-community.org bugzilla-daemon at bugs.koha-community.org
Thu Jan 25 22:23:14 CET 2024


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

--- Comment #2 from Caroline Cyr La Rose <caroline.cyr-la-rose at inlibro.com> ---
If someone stumbled upon this and needs to correct their suggestions:

Changing the authorized value (this can be done via the staff interface under
Administration > Authorized values > SUGGEST_STATUS):

UPDATE authorised_values SET authorised_value = 'SPACELESS_STATUS' WHERE
category  = 'SUGGEST_STATUS' AND authorised_value = 'Old status';


Changing the suggestions themselves (this must be done in the db):

UPDATE suggestions SET STATUS = 'SPACELESS_STATUS' WHERE STATUS = 'Old status';


If you had notices linked to that status (this must be done in the db also):

UPDATE letter SET code = 'SPACELESS_STATUS' WHERE code = 'Old status';

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


More information about the Koha-bugs mailing list