MAX_NUM_BOX_CONTROL_ITEMS

Description:

This parameter specifies the maximum number of records that will be returned in DBComboBoxUI, DBListBoxUI and DBLookupUI.

For DBListBoxUI and DBComboBoxUI, if the keyword DISTINCT 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 without DISTINCT 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