tn.query.maxrows
Default number of rows that query services return. The query services are services in the wm.tn.query folder. Use the input variable for the query services to specify a maximum number of rows to return from a query. If you do not specify the number of rows to return when you start a query service, the query service uses this property. If a query returns more rows than allowed by this property, the query service silently drops the rows that exceed the number you specify. The default is 0, which indicates no maximum.
Note:
Use the input variable maxRowCount to specify the maximum number of rows to return from a query. If you do not specify the number of rows to return when you start a query service, the query service uses the tn.query.maxrows property. If a query returns more rows than the value specified (maxRowCount or tn.query.maxrows), the query service drops the rows that exceed the value.
The default value zero indicates no maximum, that is, the query returns all the rows. If you do not specify maxRowCount and did not configure the tn.query.maxrows property, the query returns all the rows.
If the tn.query.maxrows property is configured with a value less than zero, the value that is specified in the tn.db.fetchMaxRows property is used. If the tn.db.fetchMaxRows property is not configured, then its default value of 10000 is used.