COUNT

Returns count of the rows displayed in the table control. This function is called as <TableControlName>.COUNT("ControlName"). Use a TableControl instance to indicate which TableControl contains the values to be operated on by the function (e.g., Order_DetailsTableControl, ProductsTableControl, CategoriesTableControl).

Note: This function returns the count of the rows displayed on the page.  This will be less than or equal to the number of rows set in the pagination control.  Specifically, it does not return the count of all of the records on all pages.  Only the count of the records on the currently displayed set of rows is returned.

Syntax

= <TableControlName>.COUNT(controlName)

Parameters

controlName

It represents the name of the control which contains the values whose count is to be determined. The controlName should be a string (e.g., “UnitPrice”, “Quantity”, Discount). The values in the control can be an integer (e.g., 37), a decimal value (e.g., 37.48), a string (“IronSpeed”), or a null value.

Return Type

Decimal

Examples

Example

Returns

= ProductsTableControl.COUNT(“UnitPrice”)

The number of rows in the “UnitPrice” control.

= Order_DetailsTableControl.COUNT ("Quantity")

The number of rows in the “Quantity” control.

= Order_DetailsTableControl.COUNT ("Discount")

The number of rows in the “Discount” control.