numRows

This object allows you to specify a SELECT query, which will be executed in the database. The object then returns the number of rows, which were returned by the query.

Properties

table

table
Data type

Table name

Name of the database table to query.

select

select
Data type

select

Select query for the operation.

The sub-property selectFields is overridden internally with count(*).

Example

Get the number of content elements within certain colPos of the current page.

EXT:site_package/Configuration/TypoScript/setup.typoscript
10 = FLUIDTEMPLATE
10 {
    variables {
        numberOfContentElementsInColPosOne = TEXT
        numberOfContentElementsInColPosOne.numRows {
            table = tt_content
            select.where = {#colPos}=1
        }
    }
}