DB Options
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}