UPDATE 9/5/2020. In OpenVPMS 2.2, unlimited notes are supported using the existing document support. See https://openvpms.atlassian.net/browse/OVPMS-2292

Patient clinical note fields are limited to 5000 characters at present, requiring long notes to be split accross multiple Note records.

This project will add support for large text documents that can be used to store notes of practically unlimited length.

Initially, the text documents will be used to store patient clinical notes, but could be used to store any text record in future, including html.

This will require a modification to the OpenVPMS database schema to add a new text_documents table. This will be similar to the documents table but have a longtext column instead of a longblob. The longtext column will be easier to search and report.

Changes required:

• add text_documents table to store text
• add framework support for text documents
• change act.patientClinicalNote archetype to use a text document for its note field
• change act.patientClinicalNote editor to edit text documents
• add support to migrate existing databases. This includes:
  • updating the schema to include the text_documents table
  • migrating existing act.patientClinicalNote data