When requesting entities by API, attributes represented by mediumtext in MySQL are truncated even though in entity manager it is defined with ''Disable Text Cut" for the attribute.
This bug only occurs when the query is done to the whole entity list. Querying an ID works fine.
Steps to reproduce the bug:
1. In EspoCRM administration define an entity
2. Define an attribute of type 'Text' which will create a textbox in the EspoCRM dataset and a 'mediumtext' field in a MySQL database. Check 'Disable Text Cut' for this attribute.
3. Insert a record and use huge text for the attribute created above. I use the attribute to store a big JSON object which is needed by an external application.
4. Now query ...
4a. the whole entity list: GET https://<domain>/api/v1/<entity>
4b. only the ID of the record created above: GET https://<domain>/api/v1/<entity>/<ID>
For 4a the results of the textbox attribute will be truncated. For 4b the results will correctly not be truncated.
The problem is, that 4a destroys the JSON objects which causes problems in the application querying the entity list.
Environment:
* EspoCRM version: 5.7.6
* Advanced Pack 2.4.1
This bug only occurs when the query is done to the whole entity list. Querying an ID works fine.
Steps to reproduce the bug:
1. In EspoCRM administration define an entity
2. Define an attribute of type 'Text' which will create a textbox in the EspoCRM dataset and a 'mediumtext' field in a MySQL database. Check 'Disable Text Cut' for this attribute.
3. Insert a record and use huge text for the attribute created above. I use the attribute to store a big JSON object which is needed by an external application.
4. Now query ...
4a. the whole entity list: GET https://<domain>/api/v1/<entity>
4b. only the ID of the record created above: GET https://<domain>/api/v1/<entity>/<ID>
For 4a the results of the textbox attribute will be truncated. For 4b the results will correctly not be truncated.
The problem is, that 4a destroys the JSON objects which causes problems in the application querying the entity list.
Environment:
* EspoCRM version: 5.7.6
* Advanced Pack 2.4.1
Comment