Configuring Value Lists with Tables

You can use tables and views to select parameter values, validation lists, and selection lists.

Here's a sample configuration from the xls.handlers table:

ID	TABLE_SCHEMA	TABLE_NAME	COLUMN_NAME	EVENT_NAME	HANDLER_SCHEMA	HANDLER_NAME	HANDLER_TYPE	HANDLER_CODE
	s02	usp_cashbook	company_id	ValidationList	s02	companies	TABLE	id, +name
	s02	usp_cashbook	company_id	ParameterValues	s02	companies	TABLE	id, +name

Note the HANDLER_CODE values: id, +name. This code specifies the selected columns and their sort order.

When you use SaveToDB and DBEdit, they execute the following command based on this declaration:

SELECT id, name FROM s02.companies ORDER BY name

DBGate publishes these validation lists using the system $select and $orderBy parameters, formatted as:

s02/companies?$select=id,name&$orderBy=name

Value lists can be filtered or dynamic and can accept one, two, or three columns.