Hi, What is the best way to set the default_limit to something like 12345678 ? Suppose that I need and I want more than 1000 rows.

I can’t figure out what default_limit you’re talking about. I don’t see that in site_settings.yml. What are you trying to do? And are you trying to do it in a plugin or theme component (since you posted in dev)?

The data-explorer plugin’s default_limit… [Capture d’écran, le 2022-01-07 à 18.07.22]

[imagem] How to bump 10k records csv export limit in Data Explorer? Development 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 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.

Ok, the only way is to set another value like this: I was hoping there was a better way in Discourse’s settings UI. ./launcher enter app cd /var/www/discourse/plugins/discourse-data-explorer/ sed -i 's/QUERY_RESULT_DEFAULT_LIMIT = 1000/QUERY_RESULT_DEFAULT_LIMIT = 12345678/g' /var/www/discourse/plugins/discourse-data-explorer/plugin.rb sed -i 's/QUERY_RESULT_MAX_LIMIT = 1000/QUERY_RESULT_MAX_LIMIT = 12345678/g' /var/www/discourse/plugins/discourse-data-explorer/plugin.rb

[imagem] Donavan_Martin1: the only way Certainly not the only way. As per my link, you can fork the plugin, change the constant and clone your fork. You could always PR a plugin setting to that plugin …

Not the only way. It’s possible to make changes like that with launcher. You can log at the other templates for examples of how to make changes to files.

If this isn’t the only way, can you provide an example thanks.

They recently change the code to a new hidden settings… https://github.com/discourse/discourse-data-explorer/commit/70b973ea9a5290614d7ddd772433c2f6fcca7cba#r66512267

cd /var/discourse ./launcher enter app sed -i 's/QUERY_RESULT_DEFAULT_LIMIT = 1000/QUERY_RESULT_DEFAULT_LIMIT = 10000000/g' /var/www/discourse/plugins/discourse-data-explorer/plugin.rb sed -i 's/QUERY_RESULT_MAX_LIMIT = 1000/QUERY_RESULT_MAX_LIMIT = 10000000/g' /var/www/discourse/plugins/discourse-data-explorer/plugin.rb sed -i 's/default: 1000/default: 10000000/g' plugins/discourse-data-explorer/config/settings.yml sed -i 's/max: 10000/max: 10000000/g' plugins/discourse-data-explorer/config/settings.yml rails c SiteSetting.data_explorer_query_result_limit=1000000 exit exit reboot

How can one change such a “hidden setting” in the most forward way? I hope it does not require editing code to change such a basic limit of the plugin.

Como alterar o response default_limit no data explorer?

Dev

n1bff 9 Novembro , 2023 16:10 15

Obrigado, esse parâmetro limit=ALL resolve para mim.

Tópico		Respostas	Vistas
How to export more than the 10,000 limit? Development data-explorer	3	1115	14 Setembro , 2022
How to bump 10k records csv export limit in Data Explorer? Development data-explorer	6	1444	30 Novembro , 2021
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
Working around the 10,000 result limit of data explorer? Data & reporting data-explorer , sql-query	2	300	26 Junho , 2024

Como alterar o response default_limit no data explorer?

Related topics