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: koha-bugs@lists.koha-community.org Reporter: schodkowy.omegi-0r@icloud.com QA Contact: testopia@bugs.koha-community.org 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.