Description


This macro requires the Scaffolding add-on

Provides list options to a List Data macro based on values in a database table. If you require more control over the list options, see Populating Scaffolding Select Lists Using SQL Queries for some advanced use cases.

Parameters

Name
Required
Default Value
Description

Data Source

Yes


Name of the data source containing the table

Table

Yes


Table name

Value column

Yes


Database column with unique values to identify each list option

Label column

No


Database column with text labels for each list option

Sort value column

No


Database column whose values determine the sorting of list options

Examples

{list-data:name=user}
{db-options:ds=myDs|table=user|valueCol=user_id|labelCol=user_name}
{list-data}
CODE