How to set limit to dropdownlistbox from default 50
Creation date: 21/06/2022 15:57
Updated: 21/06/2022 15:57
Question:
Answer:
Investigation:
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.
DataImage6.png
DataImage29.png
DataImage93.png
DataImage8.png