table export limit #4989
-
|
When I try to export an entire table, budibase only exports 5000. I have not been able to find a way to adjust or eliminate that parameter. Can anyone tell me how to do that? |
Beta Was this translation helpful? Give feedback.
Replies: 3 comments 5 replies
-
|
Hi @gpjorgenson - just to confirm, are you trying to export a SQL table? |
Beta Was this translation helpful? Give feedback.
-
|
Yes, it is a postgresql table. |
Beta Was this translation helpful? Give feedback.
-
|
Hi @gpjorgenson - I've added a change to PR #4991 - once released it'll allow you to change the environment variable For the Cloud, we have to maintain the limit of 5000 rows per query (this extends to export as well) and therefore this cannot be raised. |
Beta Was this translation helpful? Give feedback.
-
|
Thank you. We are self host with the database on our own server. I will look forward to that release. |
Beta Was this translation helpful? Give feedback.
-
|
Yes
From: Michael Drury ***@***.***>
Sent: Monday, March 21, 2022 11:38 AM
To: Budibase/budibase ***@***.***>
Cc: gpjorgenson ***@***.***>; Mention ***@***.***>
Subject: Re: [Budibase/budibase] table export limit (Discussion #4989)
Hi @gpjorgenson <https://github.com/gpjorgenson> - just to confirm, are you trying to export a SQL table?
—
Reply to this email directly, view it on GitHub <#4989 (comment)> , or unsubscribe <https://github.com/notifications/unsubscribe-auth/AFSR7X5UODKVG7W6HOBGFJDVBCXWZANCNFSM5RIKGXGA> .
You are receiving this because you were mentioned. <https://github.com/notifications/beacon/AFSR7X2GIXZXAK7JYNDS7B3VBCXWZA5CNFSM5RIKGXGKYY3PNVWWK3TUL52HS4DFWFCGS43DOVZXG2LPNZBW63LNMVXHJKTDN5WW2ZLOORPWSZGOAASMDBY.gif> Message ID: ***@***.*** ***@***.***> >
|
Beta Was this translation helpful? Give feedback.
-
|
Which container in a Docker deployment would I add this env variable to? |
Beta Was this translation helpful? Give feedback.
-
|
environment variables to do with app operations should be added to the |
Beta Was this translation helpful? Give feedback.
-
|
When I add SQL_MAX_ROWS to the apps container I get a 502 error (Bad Gateway). Its pulling budibase/apps:latest, but when I deploy using the script and docker-compose, it deploys budibase/apps. Disregard, just added it to the docker-compose and redeployed. |
Beta Was this translation helpful? Give feedback.
When I add SQL_MAX_ROWS to the apps container I get a 502 error (Bad Gateway). Its pulling budibase/apps:latest, but when I deploy using the script and docker-compose, it deploys budibase/apps.
Disregard, just added it to the docker-compose and redeployed.