Limit

The Limit node takes a slice of rows from the input array. Use it for pagination, "top N" lists, or to cap the number of items displayed.

Configuration

Property	Type	Default	Description
count	number	10	Maximum number of rows to return (capped at 1,000).
offset	number	0	Number of rows to skip before taking the slice.

Input

Accepts an array of rows.

Output

Returns a subset of the input rows, starting at offset and containing up to count rows.

How It Works

The node uses PHP array_slice($input, $offset, $count) to extract the requested portion of the array.

Example Use Cases

Show top 5 items

count: 5
offset: 0

Paginated display (page 3, 10 items per page)

count: 10
offset: 20

Skip the first item

count: 100
offset: 1

Useful when the first row is a header or summary row.

Combined with Sort for "Top N"

Table Query --> Sort (field: "score", direction: "desc") --> Limit (count: 10) --> Result

This produces the top 10 highest-scoring items.

TIP

When possible, use the limit and offset options on source nodes to paginate at the database level. The Limit node is useful for limiting data after transforms or combining multiple sources.