[image] Discourse Data Explorer Clicking Export will let you download the results with a much higher limit of 10,000. Dumb question - that ceiling is looming closer for one of our forums. Can we exceed it without forking the plugin? It looks like there is a hidden setting for the default 1000…

A way to test would be to enter the container, edit /var/www/discourse/plugins/discourse-data-explorer/plugin.rb and change QUERY_RESULT_MAX_LIMIT = 10000, do a sv restart unicorn and see what happens. Of course there are reasons not to allow such huge queries; if you’re confident of your infrastruc…

Thanks for this advice, Jay. I have indeed thought about writing a plugin but also that it should be doable from the rails console as for the various bulk operations but I don’t know rails and that anyway appears to require triggering mbedded functions. That would create the same overwrite problem u…

How to export more than the 10,000 limit?

Development

DonH September 13, 2022, 2:32am 2

I am coincidentally tonight also up against this 10,000 record limit. Is there a way to breach it? I need another order of magnitude.

Topic		Replies	Views
How to bump 10k records csv export limit in Data Explorer? Development data-explorer	6	1437	November 30, 2021
How to change the response default_limit in data explorer? Development data-explorer	14	2012	November 9, 2023
Creating a plugin to override QUERY_RESULT_MAX_LIMIT Development data-explorer	6	596	December 5, 2024
Working around the 10,000 result limit of data explorer? Data & reporting data-explorer , sql-query	2	297	June 26, 2024
Has something changed in the data explorer? Can't get query via API Product Support data-explorer , rest-api	8	280	March 11, 2026

How to export more than the 10,000 limit?

Related topics