surrealdb / surrealist

Surrealist is the ultimate way to visually manage your SurrealDB database
https://surrealist.app/
MIT License
1.06k stars 81 forks source link

explorer missing defined optional columns when query does not contain any #171

Closed singersbalm closed 7 months ago

singersbalm commented 7 months ago

Describe the bug Columns in record explorer not based on table structure, but db response. optional columns do not show up if the response does not contain any results for this column. If I go to a page where the value is set it changes the table structure.

To Reproduce Steps to reproduce the behavior:

  1. create structure with optional column
  2. create 10 entries with none value in this column
  3. create 1 entry with something in the column
  4. goto explorer and select 10 per page
  5. go to next page

Expected behavior A clear and concise description of what you expected to happen.

Environment (you can view the current version under Settings):