hasura / hasura/graphql-engine
Console: Run SQL HTML results are now div instead of table; can't copy/paste into spreadsheet editor anymore
- Dominant language
- TypeScript
- Stars
- 32.1k
- Forks
- 3k
- PR merge metrics
- PR metrics pending
Description
### Discussed in https://github.com/hasura/graphql-engine/discussions/8855
Originally posted by **carlpaten** August 18, 2022
### Version Information
Server Version: v2.4.0
CLI Version (for CLI related issue): v2.4.0
### Environment
OSS
### What is the current behaviour?
When using the Run SQL page, tabular results are returned as a series of nested divs, which cannot be pasted into a spreadsheet editor without losing the table structure
### What is the expected behaviour?
As in Hasura 1.x, the Run SQL page should show tabular results using HTML ``
### How to reproduce the issue?
1. Visit `/console/data/sql`
2. `SELECT` some multi-row, multi-column dataset
3. Inspect results; view that the table is made of `
4. Try to paste into Google Sheets and see that it doesn't work
### Keywords
hasura web console run sql html table div copy paste google sheets microsoft excel
Contributor guide
Research direction
Start at the Console route /console/data/sql and reproduce the issue with a multi-row, multi-column SELECT. Inspect the rendered results and verify that the completed change restores table structure and allows copying into Google Sheets or Microsoft Excel without losing rows and columns.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- typescript
- Domain
- frontend
- Issue type
- Bug
- Difficulty
- 3/5
- Estimated time
- 1-2 days
- Activity status
- Stale
- Clarity
- Clearly specified
- Newbie friendliness
- 45/100