Loading a Combo Box from Cache

The Load From Cache system function enables you to load a combo box from a JD Edwards EnterpriseOne cache data source. Runtime will load values from cache only if the target combo box control is based on a valid DD item that does not have a UDC list associated with it.

When working from cache, you must have a prepared data structure to govern loading data from source into the cache and then transferring it from the cache to the combo box control. When you choose (or create) a data structure to use for this purpose, ensure that the Key, Item, and optional Filter Column parameter data types are compatible with the corresponding data types demanded by the system functions you will call.

Note: All of the values are retrieved from cache prior to filtering. Therefore, you should avoid loading large quantities of data into cache to reduce the possibility of poor performance.

The JD Edwards EnterpriseOne cache from which the combo box item data will be read must have defined a distinct column containing one or more rows of data for each of these combo box data items:

• E1 Cache Column - Keys (values)

• E1 Cache Column - Items (descriptions)

• E1 Cache Column - Filter Column Values (optional filter value)

If the optional filter cache column is not designated or does not contain valid data, runtime will retrieve and load into the combo box all of the key/description pairs currently loaded in the specified cache. After the combo box has been loaded from the cache, you can dynamically remove items from its item list using the Remove Item system function.