Need to Increase Data Size for `form_values` column on civicrm_report_instance table
Overview
Currently form_values column of the civicrm_report_instance table is of data type TEXT. This is sufficient for saving most report instances. However we have a couple of custom reports based on the Core Civi report functionality with some dynamic filters that may vary based on some conditions in the system. As such some of the reports have a lot of custom form filters fields and when these reports are saved in the database, the serialized data in the form_values
column of the civicrm_report_instance table gets truncated and this renders the saved report unusable.
Proposed behaviour
The Proposal is to change the data type of the form_values column of the civicrm_report_instance table to MEDIUMTEXT which can hold much more data (~16MB) as compared with TEXT (64KB). With this change, the data will not be truncated and any custom report form with much form fields will not having any issue getting saved at all.