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 ¶

Type: Table name

Name of the database table to query.

select¶

select ¶

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
        }
    }
}