dosubot[bot] commented on issue #31626: URL: https://github.com/apache/superset/issues/31626#issuecomment-2563083171
<!-- Answer --> There are two similar unsolved discussions related to table chart pagination issues in Superset: 1. [Table chart pagination not working since version 4.1.0](https://github.com/apache/superset/discussions/31603), last updated on December 23, 2024 <sup>[[1]](https://github.com/apache/superset/discussions/31603)</sup>. 2. [Table Chart](https://github.com/apache/superset/discussions/31568), last updated on December 19, 2024 <sup>[[2]](https://github.com/apache/superset/discussions/31568)</sup>. Regarding your issue, it seems that the 'server page length' setting is crucial for the pagination to work correctly. When you set it to 200, the records update as expected, but with the default value of 10, it doesn't update beyond that. This behavior might be related to how the 'server page length' interacts with the pagination controls. The 'server page length' determines the number of rows displayed per page when server-side pagination is enabled, and setting it to 0 means no pagination will be applied <sup>[[3]](https://github.com/apache/superset/blob/master/superset-frontend/plugins/plugin-chart-handlebars/src/plugin/controls/pagination.tsx)</sup><sup>[[4]](https://github.com/apache/superset/blob/master/superset-frontend/plugins/plugin-chart-table/src/controlPanel.tsx)</sup>. Additionally, there are conditions in the code that could prevent the pagination dropdown menu from updating the number of displayed records, such as the `limitingFactor` property, `limitReached` flag, and `defaultQueryLimit` <sup>[[5]](https://github.com/apache/superset/blob/master/superset-frontend/src/SqlLab/components/ResultSet/index.tsx)</sup>. You might want to check if the 'server pagination' option is enabled and ensure that the 'server page length' is set appropriately to see if it resolves the issue. <!-- Dosu Comment Footer --> *To continue talking to [Dosu](https://dosu.dev), mention @dosu.* --- <sup>Help Dosu learn! Give it feedback: [Great Response](https://app.dosu.dev/response-feedback/9b156fef-2f99-432e-bce0-89240ac64faa?feedback_type=great_response) | [Irrelevant Answer](https://app.dosu.dev/response-feedback/9b156fef-2f99-432e-bce0-89240ac64faa?feedback_type=irrelevant_answer) | [Incorrect Sources](https://app.dosu.dev/response-feedback/9b156fef-2f99-432e-bce0-89240ac64faa?feedback_type=incorrect_sources) | [Too Verbose](https://app.dosu.dev/response-feedback/9b156fef-2f99-432e-bce0-89240ac64faa?feedback_type=too_verbose) | [Hallucination](https://app.dosu.dev/response-feedback/9b156fef-2f99-432e-bce0-89240ac64faa?feedback_type=hallucination) | [Other](https://app.dosu.dev/response-feedback/9b156fef-2f99-432e-bce0-89240ac64faa?feedback_type=other)</sup> -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
