Bug 39230 - Increase field size of letter.title
Summary: Increase field size of letter.title
Status: NEW
Alias: None
Product: Koha
Classification: Unclassified
Component: Notices (show other bugs)
Version: 24.05
Hardware: All All
: P5 - low enhancement
Assignee: Bugs List
QA Contact: Testopia
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2025-03-03 17:43 UTC by Michał
Modified: 2025-03-21 01:44 UTC (History)
0 users

See Also:
GIT URL:
Change sponsored?: ---
Patch complexity: ---
Documentation contact:
Documentation submission:
Text to go in the release notes:
Version(s) released in:
Circulation function:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
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)"