Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Joget允许您使用默认MySQL以外的其它关系型数据库:

Children Display

Increase the Limit of Items/Elements in Form/Datalist/Userview Builder and Process Builder

In Joget Workflow, all your designed forms, datalists, userviews and also the process flows are stored in the database. The number of items/elements you can add in to your builder is actually limited by the database column that store the definition of your design. To increase the limit, you can do the following steps for each builder. 

Note

The steps outlined below are applicable to MySQL database only. Please consult your database administrator for steps pertaining to other databases.  

提升表单/列表/用户界面/流程设计器元素数量限制

在Joget Workflow, 您所有的表单,列表,用户界面和流程设计都保存在数据库. 在设计中的元素数量会受到数据库字段类型的限制. 想提升限制, 您可以按以下方式实现. 

Note
title注意

以下步骤仅限于MySQL数据库. 其它数据库请咨询相应的数据库管理员.  

1. 提升 my.ini  1. Increase the "max_allowed_packet" setting in my.ini of MySQL for huge data. At the end of the my.ini file content, add this line提升MySQL数据包大小限制,添加以下配置:

Code Block
max_allowed_packet=32M

2. Increase the limit of Process Builder 提升流程设计限制 (Workflow Designer); run the following 运行以下 SQL:

Code Block
ALTER TABLE SHKXPDLData CHANGE XPDLContent XPDLContent LONGBLOB;
ALTER TABLE SHKXPDLData CHANGE XPDLClassContent XPDLClassContent LONGBLOB;

3. Increase the limit of Form Builder; run the following 提升表单设计限制; 运行以下 SQL:

Code Block
ALTER TABLE app_form CHANGE json json LONGTEXT;

4. Increase the limit of Datalist Builder; run the following SQL提升列表设计限制; 运行以下SQL:

Code Block
ALTER TABLE app_datalist CHANGE json json LONGTEXT;

5. Increase the limit of Userview Builder; run the following SQL提升用户界面设计限制; 运行以下SQL:

Code Block
ALTER TABLE app_userview CHANGE json json LONGTEXT;

6. Increase the limit of Process Tool Plugin properties; run the following SQL提升流程工具和插件设计限制; 运行以下SQL:

Code Block
ALTER TABLE app_package_activity_plugin CHANGE pluginProperties pluginProperties LONGTEXT;