MAX_NUM_BOX_CONTROL_ITEMS
- Description:
-
This parameter specifies the maximum number of records that will be returned in
DBComboBoxUI
,DBListBoxUI
andDBLookupUI
.For
DBListBoxUI
andDBComboBoxUI
, if the keywordDISTINCT
is used in the SQL query, it will be stripped before the query is run. If distinct values need to be returned, the SQL query should be created in such a way that unique results are returned without the use of the keyword DISTINCT. Examples of how to write a query with and withoutDISTINCT
are found below.An example with
DISTINCT
:SELECT DISTINCT SO.ACT_ID, SO.ACT_NAME FROM VL_SO_ACTIVITY SO, SEC_EMPLOYEE SE, VL_SO_SCHEDULE_GROUP SG ,ES_ACT_TYPE_MAP EATM WHERE SO.SKDGRP_ID = SG.SKDGRP_ID AND SG.WBT_ID = SE.WBT_ID AND EATM.ACT_ID = SO.ACT_ID AND EATM.ESACTTYPE_ID =0 AND SE.wbu_id = ? ORDER BY ACT_NAME;
A similar example without the use of
DISTINCT
:SELECT SO.ACT_ID, SO.ACT_NAME FROM VL_SO_ACTIVITY SO WHERE EXISTS ( SELECT 1 FROM VL_SO_ACTIVITY S, SEC_EMPLOYEE SE, VL_SO_SCHEDULE_GROUP SG ,ES_ACT_TYPE_MAP EATM WHERE SO.SKDGRP_ID = SG.SKDGRP_ID AND SG.WBT_ID = SE.WBT_ID AND EATM.ACT_ID = S.ACT_ID AND EATM.ESACTTYPE_ID =0 AND SE.wbu_id = ? AND SO.ACT_ID = S.ACT_ID) ORDER BY ACT_NAME;
- Valid Values:
-
Any positive integer
- Default Value:
-
100
- Location:
-
system/WORKBRAIN_PARAMETERS/
- Effective:
-
n/a