hasura / hasura/graphql-engine
Export function in the RAW SQL page and options for results pagination.
- Dominant language
- TypeScript
- Stars
- 32.1k
- Forks
- 3k
- PR merge metrics
- PR metrics pending
Description
From a Hasura Cloud user ticket:
```
Hi, this is a feature request. With the Hasura 2.0.7 cloud I would love to have an export function in the RAW SQL view to export the data as a datasheet or CSV. In previous versions of 1.3.X the I could simply copy and paste the table directly into a sheet (Google Sheets, Excel and Numbers) placing the data nicely into organized columns.
Today with Hasura 2.0.X this is not possible and the data is all put into one column on separate rows. Also, in previous versions you could also have unlimited number of rows in the result of your RAW SQL query which is now capped to 100 rows. I understand this is done for performance reasons, but it would awesome if this could set as an option to show up to 1000 rows on one page.
```
Contributor guide
Research direction
The issue concerns the RAW SQL page, its result export, and the current 100-row cap. Start by locating the RAW SQL page and its result rendering or pagination entry points; define how CSV or datasheet output and an optional 1,000-row page should behave, then verify both requests in the relevant UI tests.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- typescript
- Domain
- frontend
- Issue type
- Feature
- Difficulty
- 4/5
- Estimated time
- 3-5 days
- Activity status
- Stale
- Clarity
- Mostly clear
- Newbie friendliness
- 25/100