Non-blocking Note limit Increase
We have recently been coming up against an error when adding additional notes to the Non-blocking notes field. There is a current character limit of 4,000 characters that's not noted anywhere I could find on the help section. Can this character limit be updated, as there are many instances where notes need to be kept for historical purposes?
-
Phil Agnew
commented
While I'm not opposed to increasing the character limit, I think you might be better served by looking into the Dated Note functionality added in 8.0. If the limit were increased, you'd probably just find yourself in the same boat again later. If you shifted to using Date Notes for more historical purposes, you'll never run into this problem again, since each Dated Note is it's own entry. It is a little confusing having "Notes" AND "Dated Notes" though... the feature was added just before our Go Live date, so I was able to use some REGEXP_SUBSTR() queries targeting carriage returns to slice our existing note blocks into separate entries to add as "Dated Notes" (not perfect, but serviceable) and disabled the standard "Notes" in favor of "Dated Notes". I know something like that isn't a viable option for everyone, but you could conceivably start transitioning over to Date Notes by manually copying note data, starting with your most "robust" patron accounts... though it would be nice to be able to optionally change the "Date" value for "Dated Notes" created this way... That might be another "Idea"...