I only recently noticed that a table I have is not abiding by the number of items to display set in the database it is linked to.
The pagination bars show that there are two pages but the table is showing the whole collection. Clicking the pagination bar seems to force the table to refresh and the number on the pagination bar changes but what the table displays is unaffected. The collection only has 22 items and the table displays them all. The items to display in the database is set to the default 20.
Checking the page with a repeater and the same pagination bars, the page behaves correctly. Clicking the pagination bar re-updates the page with the 2 items that were not displayed.
Is there a setting that I missed to limit the table?