cannectors

pagination

pagination configuration for the database module.

propertytypedefaultdescription
type
stringPagination type.
limit-offsetcursor
limit
integerNumber of records per page. Optional; runtime applies default when omitted.
param
stringNamed placeholder used in the SQL query to inject the cursor or offset value (e.g. ':cursor' / ':offset').
cursorField
stringField of the previous page's last record used as the next cursor value (cursor pagination only).