How to set limit to dropdownlistbox from default 50

Creation date: 21/06/2022 15:57 Updated: 21/06/2022 15:57 #dropdownlistbox #limit50

Question:

Company: CJ Express

Contact: Natnicha Wiriyamanikan

Email:natnicha.wi@cjexpress.co.th

Priority :P3

Impact : We can't set dock door in Zone menu

Environment : WMS PRODUCTION (Warehouse D001)

Problem Information

We can't set dock door in Zone menubecausedropdowns dock door don’t show all dock door master.

Answer:

Investigation:

The dropdownlist was limit to 50.

022-06-21 10:51:03:761: (WMS01)SELECT dockNo AS CODEID, dockNo AS CODETEXT FROM BAS_DOCK WHERE warehouseId = 'D001' AND organizationId = 'CJ' AND organizationId = 'CJ' LIMIT 50 (WMS01)查询结果:50 (耗时:9)

Set the limit to 500 by the following steps:

1) Go to Data source -> click on UDF Form - choose the right schema.

2. Go to the dropdownlist -> clicn on the udf sql

3. There is a default limit of 50. Can change it to 500

4. Click confirm then save schema. Refresh and the dropdownlistbox can display up to 500 lines.

Files		Sort by Name Sort by Date
	DataImage8.png 48 KB
	DataImage93.png 49 KB
	DataImage29.png 19 KB
	DataImage6.png 18 KB

How to set limit to dropdownlistbox from default 50

Contents