Bug 27374

Summary:	Add possibility to attach arbitrary notes to items
Product:	Koha	Reporter:	Katrin Fischer <katrin.fischer>
Component:	Acquisitions	Assignee:	Bugs List <koha-bugs>
Status:	NEW ---	QA Contact:	Testopia <testopia>
Severity:	enhancement
Priority:	P5 - low	CC:	dcook, josef.moravec, kyle, magnus
Version:	Main
Hardware:	All
OS:	All
See Also:	https://bugs.koha-community.org/bugzilla3/show_bug.cgi?id=17297
Change sponsored?:	---	Patch complexity:	---
Documentation contact:		Documentation submission:
Text to go in the release notes:		Version(s) released in:
Circulation function:

Description Katrin Fischer 2021-01-09 12:04:57 UTC

It would be nice if there was a way to add internal messages and notes to an item that are not recorded within the item record/MARC record. Having this information separately would also make dealing with multiple messages an additional information such as timestamps and logging the author/source possible.

We also have recurring problems with personal and other data added to item notes that then are showing up in places where they shouldn't. The last problem being that they are showing up in search and can lead to strange results especially when last names are used in notes and search. (Like publications from someone in the institution and things they suggested for purchase showing up together)

Comment 1 Magnus Enger 2021-01-11 08:18:06 UTC

Sounds like a most excellent idea! There is a precedent in the ILL comments: 

https://git.koha-community.org/Koha-community/Koha/src/branch/master/Koha/Schema/Result/Illcomment.pm

Comment 2 Kyle M Hall (khall) 2021-01-11 14:29:42 UTC

We needed this feature post-haste and since we are still in the process of settling the react/vue debate, I created a plugin as a stop-gap: https://github.com/bywatersolutions/koha-plugin-item-messages

We should consider this as a possibility for Koha, it is react based but requires no backend transpiling! In theory the same could be done for vue if that's what we go with.

Comment 3 David Cook 2021-01-11 23:16:14 UTC

(In reply to Kyle M Hall from comment #2)
> We needed this feature post-haste and since we are still in the process of
> settling the react/vue debate, I created a plugin as a stop-gap:
> https://github.com/bywatersolutions/koha-plugin-item-messages
> 

Is the react/vue debate taking place anywhere? I was wondering a bit if there was any progress on that front. I'm focused on backend stuff at the moment, but want to do more frontend in the future as it'll be easier for some changes I want to make...

> We should consider this as a possibility for Koha, it is react based but
> requires no backend transpiling! In theory the same could be done for vue if
> that's what we go with.

Sounds good. I was going to ask how you'd migrate from plugin to core but I see the database table doesn't have a plugin prefix, so that should be easy enough.

Comment 4 David Cook 2021-01-11 23:17:23 UTC

(In reply to Kyle M Hall from comment #2)
> I created a plugin as a stop-gap:
> https://github.com/bywatersolutions/koha-plugin-item-messages
> 

Oh I think you might have the wrong charset for database table in the plugin. Shouldn't that be utf8mb4 instead of utf8?

Comment 5 Kyle M Hall (khall) 2021-01-12 12:01:19 UTC

(In reply to David Cook from comment #4)
> (In reply to Kyle M Hall from comment #2)
> > I created a plugin as a stop-gap:
> > https://github.com/bywatersolutions/koha-plugin-item-messages
> > 
> 
> Oh I think you might have the wrong charset for database table in the
> plugin. Shouldn't that be utf8mb4 instead of utf8?

Good catch! The plugin is based on code from both POCs, so I had to do a lot of updates and missed that.