Creating Data for a Table (Lists)
What is a List?
A List is a table that is created using the List command. Lists can be displayed using Show Data or Show Item commands. Here is what a List looks like when displayed by Show Data.
| Year | Model | Make | |
|---|---|---|---|
| 2005 | Ford |   | |
  1   |
 |
||
How to Create a List
A List can be created by dragging the List Definition widget from the Data Access palette when in Assemble mode.
Columns can be added to the list using the List property editor.
Advanced Information: Details of a List
Lists can also be created using wiki markup by editing the page source. (Click on the Source tab).Under the covers List creates a database table with column names corresponding to Var commands included in the List definition.
List names must begin with lowercase (the id argument). This is used to distinguish a list from a wiki page, which always starts with an uppercase.
The following code creates a car list with columns make, model, and year.
{{List id="car"}}
{{Var name="year" init="2006"/}}
{{Var name="model"/}}
{{Var name="make"/}}
{{/List}}
The init argument for the Var command is used to set the initial value of the column in the database table.
The List is created or modified only when the page is edited and saved.
At run-time, the list command doesn't display anything.
The List belongs to the page that it was created on. It can be referenced on the same page simply by using the List name. It can be used from another page by specifying the page and list. For example, the car list on this page would be specified by Wiki/Docs/HowTo/CreateData/car.