Usage

=Rows(params).datasource.field:<format>

For example the following expression:

=Rows.Vendors.Name

Will return a list of vendor names joined by new lines:

Amazoon
zBay
Home Despot

Rows is usable in many cases, however is most commonly used to provide values for listboxes and auto completes.

Rows is a one way databinding and is not updatable.

Parameters

join

If the join parameter is specified, it will be be used instead of new line:

=Rows(join:,).Vendors.Name

Will return:

Amazoon,zBay,Home Despot

To specify a space, enclose it in parenthesis:

=Rows(join:(, )).Vendors.Name

Will return:

Amazoon, zBay, Home Despot

Order

Order specifies asc (ascending) or desc (descending).

=Rows(Order:asc).Vendors.Name

returns

Amazoon
Home Despot
zBay

Parameters can also be combined:

=Rows(join:(, ) order:asc).Vendors.Name

returns

Amazoon, Home Despot, zBay

Sort

By default if order is specified, the display field (.Name) will be used for sorting. There are cases however that it is necessary to sort on a different field. This example will return Names as before, but instead will sort by the ID field.

=Rows(Sort:ID Order:desc).Vendors.Name

Default order is ascending. To use descending order:

=Rows(Sort:ID Order:desc).Vendors.Name