I need a CSV export of data that goes beyond 10k rows in the CSV export, this is resulting in not all records being exported. Assuming this line is responsible for the said limit plugin.rb 3ce778ec6 register_svg_icon "info" register_svg_icon "pencil-alt" register_svg_icon "upload" end # route: /admin/plugins/explorer add_admin_route 'explorer.title', 'explorer' module ::DataExplorer QUERY_RESULT_DEFAULT_LIMIT = 1000 QUERY_RESULT_MAX_LIMIT = 10000 def self.plugin_name 'discourse-data-explorer'.freeze end end after_initialize do add_to_class(:guardian, :user_is_a_member_of_group?) do |group| return false if !current_user return true if current_user.admin? What will be the right way to bump this limit to maybe 100k or 1M records? I tried doing DISCOURSE_QUERY_RESULT_MAX_LIMIT = 1000000 in app.yml and that doesn’t seem to have any effect.

Might have to resort to plugin-ing the plugin. Create a small one called x-discourse-data-explorer and it might get evaluated afterwards. Then simply override the module constant?

That’ll be a lot of pluginception I was hoping there was a simpler way out. cc @riking

Or fork the plugin, make the change, point to your fork and rebuild? (why I didn’t respond with that first? :sweat_smile: )

That’s what I was thinking as well. If there is no other (reasonable) way out, forking is the last option. It’ll however be good to understand what is the rationale to hard limit results to 10k? maybe something breaks if more than 10k results are fetched?

“discourse-data-explorer-MAX” … I’ll get my coat! :male_detective:

Yes, that module constant is intentionally set up to be easy to override from another plugin.

Como aumentar o limite de exportação de CSV de 10 mil registros no Data Explorer?

Dev

Tópico		Respostas	Vistas
How to export more than the 10,000 limit? Development data-explorer	3	1115	14 Setembro , 2022
How to change the response default_limit in data explorer? Development data-explorer	14	2035	9 Novembro , 2023
Working around the 10,000 result limit of data explorer? Data & reporting data-explorer , sql-query	2	300	26 Junho , 2024
Creating a plugin to override QUERY_RESULT_MAX_LIMIT Development data-explorer	6	602	5 Dezembro , 2024
Has something changed in the data explorer? Can't get query via API Product Support data-explorer , rest-api	8	290	11 Março , 2026

Como aumentar o limite de exportação de CSV de 10 mil registros no Data Explorer?

Related topics