Official Content

It is a type of control similar to a combo box, and the difference is that the set of possible values are read from a database table. Two attributes are used to define a dynamic combo box: an attribute for descriptions and an attribute holding all possible values.

Dynamic combo boxes are loaded each time a transaction, work panel, or web panel storing the necessary values is loaded. All values are loaded only once (pagination on request is not available), so it is recommended that the controls be used with tables with not more than 100 records (prompts should be used for larger tables as they provide pagination on request). Although these Control Types do assist in making the application more user-friendly, their use is not recommended in intensive 'data-entry' transactions.

Item Descriptions

Specifies the attribute from which the descriptions will be loaded. The selected attribute must be of the string type.

Sort Descriptions

Sorts the attribute by description.

Note:  When Sort Description is disabled, GX will navigate the Table without any ORDER clause specified. The SQL specification doesn't state the specific order that records are to be returned, so it's going to be implementation dependent.

Item Values

Specifies the selected attribute holding all possible values. Selected attribute holding all possible values.

Example

The variable &CountryId may be defined as a dynamic combo box where the description will be CountryName and the value will be CountryId. GeneXus will define, during specification time, the table that must be used to load the dynamic combo box values (both attributes must be stored in the same table). If you desire, you may order the box by the description (Sort descriptions). Note that &CountryId and CountryId must have identical definitions.

Dynamic Combo Box Example

See Also

HowTo: Use the Dynamic Combo Box Control for Native Mobile Applications
Control Information







Last update: February 2024 | © GeneXus. All rights reserved. GeneXus Powered by Globant