of of count

In the from of a column that the engine keeps, the table whose rows the count is worked out of.

Value

The table, as its definition or as its name. It is required. Its rows lie in the same data file as the row that keeps the number.

Example

openOrders: number({ from: count({ of: orders, by: 'customer', where: { status: 'open' } }) })

Errors

code.T2025: the counted rows lie in another data file than the row that holds the number.

See also

word.count, topic.types