Limit in workflow conditions for multienum fields #5236

New issue

Open

opened 2026-02-20 16:31:49 -05:00 by deekerman · 0 comments

deekerman commented

2026-02-20 16:31:49 -05:00

Owner

Originally created by @SinergiaCRM on GitHub (Aug 8, 2024).

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

Go to Studio and create a Multi-Select field where the dropdown list has many values.
Create a Workflow that includes a condition to evaluate if all values of the created field are selected.
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

Originally created by @SinergiaCRM on GitHub (Aug 8, 2024). ### 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