Limit in workflow conditions for multienum fields

[SinergiaCRM]

Issue

If you attempt to select multiple options from a multienum field in a workflow condition, only up to 255 characters will be saved. Multienum fields are stored as text fields in the database, while the "value" column in the aow_conditions table is of type varchar (255). If many options are selected in the multienum fields, some of them will be deselected upon saving, as the character limit has been exceeded.

Possible Fix

If we modify the file modules/AOW_Conditions/vardefs.php, changing the field type from varchar to text and removing 'len' => '255', multiple selections in the conditions are allowed.

Steps to Reproduce the Issue

1. Go to Studio and create a Multi-Select field where the dropdown list has many values.
2. Create a Workflow that includes a condition to evaluate if all values of the created field are selected.
3. Observe that after saving the Workflow, some of the values (e.g., Albacete, Zaragoza) are not saved.

Context

No response

Version

7.14.2

What browser are you currently using?

Chrome

Browser Version

127.0.6533.72 (Official Build) (64-bit)

Environment Information

MySQL, PHP Version 7.4.33

Operating System and Version

Ubuntu 22.04.4 LTS