https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39230
Bug ID: 39230
Summary: Why is there a limit on letter.title in database (of
just 200 characters)?
Change sponsored?: ---
Product: Koha
Version: 24.05
Hardware: All
OS: All
Status: NEW
Severity: enhancement
Priority: P5 - low
Component: Notices
Assignee: [email protected]
Reporter: [email protected]
QA Contact: [email protected]
So I wanted to specify subject of an e-mail in notice to: [[%
AuthorisedValues.GetDescriptionByKohaField( kohafield => 'items.location',
authorised_value => hold.item.location, opac => 1 ) %]] New hold placed ([%
ItemTypes.GetDescription(hold.item.effective_itemtype) %]; [%
Categories.GetName(borrower.categorycode) %])
But this got silently TRUNCATED. Turns out, "title" in database of "letter"
table is a varchar(200), while the above title is 262.
Can we just change the type to TEXT instead of VARCHAR(200)? That'd make it
65535 instead. I guess the limitation came from before TT templates were being
allowed. Right now you can easily have a complex templated subject that'll end
up getting transformed to a title that makes sense, so in our case above:
"[Main Warehouse] New hold placed (Borrowable Books; Student)"
--
You are receiving this mail because:
You are the assignee for the bug.
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/
