Bug 39230

Summary: Increase field size of letter.title
Product: Koha Reporter: Michał <schodkowy.omegi-0r>
Component: NoticesAssignee: Bugs List <koha-bugs>
Status: NEW --- QA Contact: Testopia <testopia>
Severity: enhancement    
Priority: P5 - low    
Version: 24.05   
Hardware: All   
OS: All   
See Also: https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=39402
GIT URL: Change sponsored?: ---
Patch complexity: --- Documentation contact:
Documentation submission: Text to go in the release notes:
Version(s) released in:
Circulation function:

Description Michał 2025-03-03 17:43:26 UTC
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)"