Releases

0.97.0 9/22/2022

πŸš€ NocoDB : Feature Release πŸš€

ERD View & Link to a Specific Row

Screenshot 2022-09-21 at 13 01 38

πŸ₯¬ What's new .. What's fresh ?

  • 🌈 ERD Views : NocoDB's user love creating tables - however without an ERD diagram its not so intuitive to understand the design of schema. Right ?
    • So we are happy to introduce ERD view at table and schema level.
    • Visualise all the relations (HasMany, ManyToMany) in the nicest possible way.
    • Drag and rearrange as you like.
  • πŸ”— Link to a row : when you expand a row in spreadsheet as a form, it wasn't possible before to send a link to your co-worker. Not any more!
    • Now you can simply expand the row - click to get the link.
    • Or even simply copy from the browser url and send it to via slack or emails. As easy as it gets.

πŸ• Demo time

🌈 ERD View

https://user-images.githubusercontent.com/5435402/191498877-4de466e6-7327-461c-8cec-702b3a6b49c9.mov

https://user-images.githubusercontent.com/5435402/191498919-af626828-0104-47e1-a653-4fadc3a3ef43.mov

πŸ‘€ Coming soon πŸ‘€ πŸŽ‰

  • πŸ“Š Kanban View: Ohhhh yes - the most liked feature, 100s of πŸ‘ on this feature by community, is in the making & its free! Can't get any better.
  • 🎨 Survey Form View: Gorgeous & limitless survey forms on your own databases.

Kanban : Sneak preview

screen-capture (1).webm

Survey form : sneak preview

https://user-images.githubusercontent.com/5435402/191495787-12711957-59b4-4a02-a33f-b6341efb09a8.mov

We cannot wait to release them soon. 🀝

πŸ› Closed Issues

  • [closed] [Feature] LDAP or SAML #3717
  • [Type: Bug] Add new row toolbar button broken for gallery view #3689
  • [closed] Creating new tags for select and multi-select columns via API [feature request] #3661
  • [Type: Bug][Type: In Development] new project displays deleted project table name's #3635
  • [closed] Webhook filter condition add/update - grid view in the background appears to reload #3633
  • [closed] Dockerfile typo #3619
  • [For: Community or Good First Issue] [API] Create columns on table type linkToAnotherRecord #3608
  • [closed] Metadata on multi-instance deployment becomes unsynchronized #3587
  • [closed] [question] sum up rows? #3586
  • [Type: Feature] vue3: shared view list- show all shared views of this table option missing #3480
  • [closed] vue3: additional network queries when filter auto apply is disabled #3479
  • [closed] vue3: signUp page if root db file is for first use #3458
  • [Scope: vue3] vue3: Documentation #3264
  • [closed] Show cover image in gallery view also if fields is not enabled [Feature] #3199
  • [Type: i18n translation] [i18n] Language support extension- #2904
  • [closed] Can't add new record for many-to-many field #2900
  • [closed] Image is not shown in gallery view when the attachment field is hidden #2864
  • [closed] "Copy Project Info" does not work on Safari #2824
  • [Type: In Development][Scope: UI / UX] sort UI broken #2781
  • [Type: Feature][Product : Project] [Feature] One-to-One Relationship #2777
  • [Type: Bug][Type: In Development][Status: Reproducible] Error on trying to rename formula column #2768
  • [For: Community or Good First Issue] [Feature] Include the name of the deleting project into the dialog #2752
  • [Type: In Development] Safari browser UI functionality issues #2666
  • [closed] Add multiple row to existing table with a csv file #2594
  • [closed] options not shown when choosing from a LTAR column (not solved yet) #2546
  • [closed] API Authentication Failure #2544
  • [closed] [Feature] npx for nocodb-dev-daily #2289
  • [closed] NocoDB: Migrate Airtable to Postgres database - attachments are missing #2269
  • [Priority: Low][Type: In Development] [LTAR] right click - clear on LTAR field, throws error #2105
  • [Type: In Development][Status: In Resolution] [UIDT-improvements] Migration considerations & other items #2037
  • [closed] Multiselect color is not shown, when more than 10 slection options are given #2002
  • [Type: In Development] LTAR field- update operation not reflected till hard refresh #1770
  • [closed] Blank inscription form when NC_DASHBOARD_URL="/" (serving by Apache) #1594
  • [closed] Primary key column contains duplicate values #1435
  • [closed] Not fetching the data of tables after meta-sync #1429
  • [closed] ERR_OSSL_EVP_UNSUPPORTED #1123
  • [closed] Virtual hasMany relationships disappears when the table metadata is recreated #851

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.96.4...0.97.0

Join Our Team

Thank you for your love & support

πŸ’œ πŸš€

0.96.4 9/13/2022

πŸš€ NocoDB : Bug Fix Release

Closed issue

  • [closed] Impossible to create a new row since 0.96 #3565
  • [Good First Issue][Status: Resolved] [Feature] Use generate button pressing enter in dialog for creating a token #3562
  • [closed] Can't upload CSV : POST on /dashboard/ fails -> 404 Not Found #3542
  • [Priority: Critical] Unable to view and download files in public share view link #3541
  • [Priority: Critical] Running nocodb without access to github #3540
  • [closed] NocoDB release action : default to master #3537
  • [Type: In Development] Release Note Issues #3524
  • [Type: Feature] [Feature] Horizontal scroll #2775
  • [Type: Feature] [Feature] Reorder multiselect options in column settings (manually or other) #1287
  • [Type: Enhancement][Type: Feature] Treeview item order #1021
  • [Type: Feature] Add mobile support #850
  • [Type: Enhancement][Good First Issue][Type: Feature][For: Community] Support SSL Certs #215

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.96.2...0.96.4

0.96.2 9/7/2022

πŸš€ NocoDB Release : Frontend is TypeScript & Vue3 πŸš€

image

What's New

  • :fire: New Frontend in Typescript
  • :fire: Moved from Vue2 to Vue3 : Composition API ❀️
  • :fire: Nuxt3: Framework Migration
  • :fire: Next generation utility-first CSS framework: Windi CSS
  • :fire: Enhanced support for JDBC URL and SSL support.
  • :fire: And we're hiring! :fire:

New UI Layout

We've rewritten the whole frontend code. Here's some screenshots.

image

image

image | image |---|---|

Typescript Migration

We've migrated existing JavaScript frontend code to Typescript. A typed frontend helps in better comprehension of our large codebase, and it comes handy as we plan to grow the team.

Framework Migration

We've migrated from Vue2 to Vue3 in which we utilise composition API for better logic reuse and more flexible code organisation. Since we are switching to Vue3, we've also migrated from Nuxt2 to Nuxt3, which is Vue3 based and it brings general optimisations and improvements.

Windi CSS

We've chosen Windi CSS as our CSS utility tool, which is able to provide faster load times and a speedy HMR in development.

Closed Issues

  • [Status: Fixed][Type: In Development] Filter Group not working with auto apply disabled #2690
  • [Status: Resolved] [i18n] Language support extension- #2685
  • [Type: Enhancement][Status: Resolved] enhancement: sort menu #2683
  • [Status: Resolved][Type: In Development] Additional % observed in filter query #2681
  • [Status: Resolved][Type: In Development] Group filter- incorrect operation #2679
  • [Type: Bug][Status: Fixed][Status: Reproducible] Error importing Chinese data #2677
  • [Status: Fixed] Error during password resetting #2673
  • [Type: Bug][Status: Fixed][Type: In Development] Cannot read properties of undefined (reading 'totalRows') #2647
  • [Type: Enhancement][Status: Resolved] Add dynamic feedback form submission #2640
  • [Type: Bug][Status: Fixed][Priority: Low][Type: In Development] Query parameter aliases not working for ExcludedList API #2635
  • [Type: Bug][Status: Fixed] Empty pills appear in lookup column, unwanted tables appear in lookup dropdown and UI issue sort #2610
  • [Status: Resolved] Can't reset the password #2607
  • [Type: Bug][Status: Fixed][Status: Reproducible] Password reset page just shows "Not a valid url" #2563
  • [Type: Bug][Status: Fixed] Filtering by formula column is broken #2562
  • [Type: Bug][DB: SQLite][Status: Fixed] m2m delete handling error #2557
  • [Type: Bug][Status: Fixed][Type: In Development] Lookup / rollup column title show's up in form view #2550
  • [Type: Bug][Status: Fixed][Status: Reproducible] Themes not working for non-creators #2539
  • [Type: Bug][Status: Fixed][Status: Reproducible] UI Problem with editor's role #2538
  • [Status: Resolved] When I try to choose a value in a many-to-many relationship NocoDB's interface doesn't show me options. #2523
  • [Type: Bug][Status: Fixed][Status: Reproducible] Filtering related records is not possible when system column is used as primary value #2517
  • [Status: Resolved][Status: Reproducible] Filtering by null in nested column not possible using API #2516
  • [Status: Resolved][Type: 0.90 Migration] issue while upgrading from 0.84.14 to 0.91.10 - migration failed #2449
  • [Good First Issue][Status: Resolved] Display picture from connected table has wrong size #2392
  • [Type: Bug][Good First Issue][Status: Fixed] Incorrect replacement of spaces in table names on mysql. #2380
  • [Type: Feature][Status: Resolved] [Feature] Set Date Format #2230
  • [Type: Enhancement][Status: Resolved] There seems to be no UI for renaming a project #1885
  • [Type: Enhancement][Good First Issue][Status: Resolved][Scope: UI / UX] Bug styling #1516
  • [Type: Feature][Status: Resolved] [Feature] In Rest api, sort randomly ? #1432
  • [Type: Enhancement][Status: Fixed] "Delete table" should be part of the tooltip menu of tables #826
  • [Type: Feature][Status: Resolved] Option to Prevent Download #807
  • [Status: Fixed] 2 issues iwp in readme.md for Windows is not a valid command, URL returns 404 #3378
  • [Status: Resolved][Type: i18n translation] [i18n] Language support extension- bn #2974
  • [Status: Resolved][Type: i18n translation] [i18n] Language support extension- hi #2941
  • [Type: Enhancement][Status: Resolved][Type: In Development] [formula] allow use of currency column in mathematical formula functions #2929
  • [Type: Question][Status: Resolved] I'm not able to create a table with the API: Cannot read properties of undefined (reading 'length') #2809
  • [Type: Enhancement][Status: Resolved] search and filter throws errors #2799
  • [Status: Resolved][Type: i18n translation] [i18n] Language support extension-fr #2743
  • [Type: Bug][Status: Fixed][Type: In Development] projectCost missing role permissions #2740
  • [Good First Issue][Status: Resolved] small problem with the menu UI under the settings module #2737
  • [Good First Issue][Status: Resolved] code snippet - baseurl how to Generate HTTPS link #2711
  • [Type: Enhancement][Type: Feature][Status: Resolved] Renaming table should rename table in database #2668
  • [Type: Feature][Status: Fixed] [Feature] Allow showing week day for dates #2606
  • [Type: Enhancement][Type: Feature][Status: Fixed] camelize is the only option for table / column infection #717
  • [Status: Resolved][Type: i18n translation] πŸ“ i18n Translations πŸ“ #633
  • [Type: Enhancement][Good First Issue][Type: Feature][For: Community][Status: Fixed] No way to change the column name for columns with foreign keys #468
  • [Type: Enhancement][Good First Issue][Type: Feature][For: Community][Status: Fixed] UX/UI: field helptext is hidden by error text #467
  • [Type: Enhancement][Good First Issue][Type: Feature][For: Community][Status: Fixed] Theme settings not consistent across browsers #429

What's Changed

New Contributors

Join Our Team

Full Changelog: https://github.com/nocodb/nocodb/compare/0.92.4...0.96.2

0.96.1 9/7/2022

πŸš€ NocoDB Release : Frontend is TypeScript & Vue3 πŸš€

image

What's New

  • :fire: New Frontend in Typescript
  • :fire: Moved from Vue2 to Vue3 : Composition API ❀️
  • :fire: Nuxt3: Framework Migration
  • :fire: Next generation utility-first CSS framework: Windi CSS
  • :fire: Enhanced support for JDBC URL and SSL support.
  • :fire: And we're hiring! :fire:

New UI Layout

We've rewritten the whole frontend code. Here's some screenshots.

image

image

image | image |---|---|

Typescript Migration

We've migrated existing JavaScript frontend code to Typescript. A typed frontend helps in better comprehension of our large codebase, and it comes handy as we plan to grow the team.

Framework Migration

We've migrated from Vue2 to Vue3 in which we utilise composition API for better logic reuse and more flexible code organisation. Since we are switching to Vue3, we've also migrated from Nuxt2 to Nuxt3, which is Vue3 based and it brings general optimisations and improvements.

Windi CSS

We've chosen Windi CSS as our CSS utility tool, which is able to provide faster load times and a speedy HMR in development.

Closed Issues

  • [Status: Fixed][Type: In Development] Filter Group not working with auto apply disabled #2690
  • [Status: Resolved] [i18n] Language support extension- #2685
  • [Type: Enhancement][Status: Resolved] enhancement: sort menu #2683
  • [Status: Resolved][Type: In Development] Additional % observed in filter query #2681
  • [Status: Resolved][Type: In Development] Group filter- incorrect operation #2679
  • [Type: Bug][Status: Fixed][Status: Reproducible] Error importing Chinese data #2677
  • [Status: Fixed] Error during password resetting #2673
  • [Type: Bug][Status: Fixed][Type: In Development] Cannot read properties of undefined (reading 'totalRows') #2647
  • [Type: Enhancement][Status: Resolved] Add dynamic feedback form submission #2640
  • [Type: Bug][Status: Fixed][Priority: Low][Type: In Development] Query parameter aliases not working for ExcludedList API #2635
  • [Type: Bug][Status: Fixed] Empty pills appear in lookup column, unwanted tables appear in lookup dropdown and UI issue sort #2610
  • [Status: Resolved] Can't reset the password #2607
  • [Type: Bug][Status: Fixed][Status: Reproducible] Password reset page just shows "Not a valid url" #2563
  • [Type: Bug][Status: Fixed] Filtering by formula column is broken #2562
  • [Type: Bug][DB: SQLite][Status: Fixed] m2m delete handling error #2557
  • [Type: Bug][Status: Fixed][Type: In Development] Lookup / rollup column title show's up in form view #2550
  • [Type: Bug][Status: Fixed][Status: Reproducible] Themes not working for non-creators #2539
  • [Type: Bug][Status: Fixed][Status: Reproducible] UI Problem with editor's role #2538
  • [Status: Resolved] When I try to choose a value in a many-to-many relationship NocoDB's interface doesn't show me options. #2523
  • [Type: Bug][Status: Fixed][Status: Reproducible] Filtering related records is not possible when system column is used as primary value #2517
  • [Status: Resolved][Status: Reproducible] Filtering by null in nested column not possible using API #2516
  • [Status: Resolved][Type: 0.90 Migration] issue while upgrading from 0.84.14 to 0.91.10 - migration failed #2449
  • [Good First Issue][Status: Resolved] Display picture from connected table has wrong size #2392
  • [Type: Bug][Good First Issue][Status: Fixed] Incorrect replacement of spaces in table names on mysql. #2380
  • [Type: Feature][Status: Resolved] [Feature] Set Date Format #2230
  • [Type: Enhancement][Status: Resolved] There seems to be no UI for renaming a project #1885
  • [Type: Enhancement][Good First Issue][Status: Resolved][Scope: UI / UX] Bug styling #1516
  • [Type: Feature][Status: Resolved] [Feature] In Rest api, sort randomly ? #1432
  • [Type: Enhancement][Status: Fixed] "Delete table" should be part of the tooltip menu of tables #826
  • [Type: Feature][Status: Resolved] Option to Prevent Download #807
  • [Status: Fixed] 2 issues iwp in readme.md for Windows is not a valid command, URL returns 404 #3378
  • [Status: Resolved][Type: i18n translation] [i18n] Language support extension- bn #2974
  • [Status: Resolved][Type: i18n translation] [i18n] Language support extension- hi #2941
  • [Type: Enhancement][Status: Resolved][Type: In Development] [formula] allow use of currency column in mathematical formula functions #2929
  • [Type: Question][Status: Resolved] I'm not able to create a table with the API: Cannot read properties of undefined (reading 'length') #2809
  • [Type: Enhancement][Status: Resolved] search and filter throws errors #2799
  • [Status: Resolved][Type: i18n translation] [i18n] Language support extension-fr #2743
  • [Type: Bug][Status: Fixed][Type: In Development] projectCost missing role permissions #2740
  • [Good First Issue][Status: Resolved] small problem with the menu UI under the settings module #2737
  • [Good First Issue][Status: Resolved] code snippet - baseurl how to Generate HTTPS link #2711
  • [Type: Enhancement][Type: Feature][Status: Resolved] Renaming table should rename table in database #2668
  • [Type: Feature][Status: Fixed] [Feature] Allow showing week day for dates #2606
  • [Type: Enhancement][Type: Feature][Status: Fixed] camelize is the only option for table / column infection #717
  • [Status: Resolved][Type: i18n translation] πŸ“ i18n Translations πŸ“ #633
  • [Type: Enhancement][Good First Issue][Type: Feature][For: Community][Status: Fixed] No way to change the column name for columns with foreign keys #468
  • [Type: Enhancement][Good First Issue][Type: Feature][For: Community][Status: Fixed] UX/UI: field helptext is hidden by error text #467
  • [Type: Enhancement][Good First Issue][Type: Feature][For: Community][Status: Fixed] Theme settings not consistent across browsers #429

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.92.4...0.96.1

Join Our Team

0.96.0 9/7/2022

πŸš€ NocoDB Pre-Release : Frontend in TypeScript & Vue3 πŸš€

image

What's New

  • :fire: New Frontend in Typescript
  • :fire: Moved from Vue2 to Vue3 : Composition API ❀️
  • :fire: Nuxt3: Framework Migration
  • :fire: Next generation utility-first CSS framework: Windi CSS
  • :fire: And we're hiring! :fire:

New UI Layout

We've rewritten the whole frontend code. Here's some screenshots.

image

image

image | image |---|---|

0.92.4 7/16/2022

πŸš€ NocoDB Feature release - Filter Groups

NOCODB : Grouped Filters

What's New

  • :fire: Filter Groups : our powerful grouped filtering is now available in GUI too (prior to this release it was only at API level)!
  • :fire: Date Formatter : Customise your date formatting to your needs.
  • :fire: Sort menu is now enhanced to toggle between asc/desc based on types.
  • :fire: And we're hiring! :fire:

Filter Groups

Filter conditions are now available to be grouped to achieve more advanced filtering.

filter (1)

Sort menu enhanced

Sort menu option texts are changed based on the column types. The sorting logic remains unchanged. Currently there are four types supported.

Type Default Reverse
Text A β†’ Z Z β†’ A
Numerical 1 β†’ 9 9 β†’ 1
Date & Time 1 β†’ 9 9 β†’ 1
Checkbox β–’ β†’ βœ“ βœ“ β†’ β–’

Example:

image

Date Formatter

When editing a Date column, users can reformat the column with one of the nine date formats introduced in this version, namely DD-MM-YYYY, MM-DD-YYYY, YYYY-MM-DD, DD/MM/YYYY, MM/DD/YYYY, YYYY/MM/DD, DD MM YYYY, MM DD YYYY, YYYY MM DD.

https://user-images.githubusercontent.com/24416449/174604861-9f945b25-6def-4d06-8f87-36c0f93a377f.mp4

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.92.3...0.92.4

Join Our Team

0.92.3 7/1/2022

πŸš€ NocoDB : Bug Fix Release

Closed issue

  • [closed] Wrong records shown when several tables are linked together #2512
  • [closed] [Feature] nc-help, nc-common source cod #2504
  • [Status: Resolved] Need a shell file to download the latest executale #2497
  • [Status: Resolved] [i18n] Language support extension-it #2491
  • [Type: Bug][Status: Fixed][Type: In Development] Can't create new tables #2464
  • [Status: Resolved] BullMQ: DEPRECATION WARNING! Your redis options maxRetriesPerRequest must be null. #2452
  • [Type: Feature][Status: Resolved] health check api #2451
  • [Status: Resolved][Scope : Documentation] docs: timely build #2447
  • [Type: Bug][Status: Fixed] Webhook trigger issue for some UI types #2443
  • [Type: Bug][Status: Fixed] diacritics are garbled in csv import #2439
  • [Status: Resolved][Priority: High][Type: In Development] LTAR: many to many #2429
  • [Type: Enhancement][Status: Resolved] handling of numerics by REPEAT() and LEN() function. Possibilities to zero-pad a numeric column #2428
  • [Type: Bug][Status: Fixed] expired token still usable #2422
  • [Type: Bug][Status: Fixed][Status: Reproducible] [FORM VIEW] Required fields can be blank #2412
  • [Status: Resolved][Type: In Development] first login attempt fails after migration #2396
  • [Type: Bug][Status: Fixed] [API] Export table as csv not work #2395
  • [Status: Resolved][DB: MSSQL][Status: Reproducible] MSSQL: udpated_at field is not updating in latest version #2379
  • [Type: Bug][DB: Postgres][Status: Fixed] PostgreSQL changing type to numeric fails for column that has space in name #2353
  • [Type: Enhancement][Status: Resolved] [Feature] Env variables for super-admin, SMTP & S3 #2319
  • [Type: Enhancement][Status: Resolved] CONCAT formula #2304
  • [Type: Bug][Status: Fixed] Failed to Update Row - 400 #1469
  • [Status: Resolved][DB: MSSQL] Unable to use non-dbo schema in mssql #1342

What's Changed

0.92.0 6/28/2022

πŸš€ NocoDB : Feature Release

image

What's New

  • πŸš€ Binary Executables
  • πŸš€ Homebrew
  • πŸš€ JSON Import
  • πŸš€ Duration Cell
  • πŸš€ And we're hiring! πŸš€

Binary Executables

NocoDB installation has gotten more seamless as we now support installation as binaries.

MacOS (x64)
curl http://get.nocodb.com/macos-x64 -o nocodb -L \
  && chmod +x nocodb \
  && ./nocodb
MacOS (arm64)
curl http://get.nocodb.com/macos-arm64 -o nocodb -L \
  && chmod +x nocodb \
  && ./nocodb
Linux (x64)
curl http://get.nocodb.com/linux-x64 -o nocodb -L \
  && chmod +x nocodb \
  && ./nocodb
Linux (arm64)
curl http://get.nocodb.com/linux-arm64 -o nocodb -L \
  && chmod +x nocodb \
  && ./nocodb
Windows (x64)
iwp http://get.nocodb.com/win-x64
.\Noco-win-x64.exe
Windows (arm64)
iwp http://get.nocodb.com/win-arm64
.\Noco-win-arm64.exe

Currently, we only support the following targets:

  • node16-linux-arm64
  • node16-macos-arm64
  • node16-win-arm64
  • node16-linux-x64
  • node16-macos-x64
  • node16-win-x64

Also you can find the release build under the release note.

image

Homebrew

Now you can use Homebrew to install NocoDB!

brew tap nocodb/nocodb
brew install nocodb
nocodb

JSON Import

Now you can import data and table from a JSON array or object.

https://user-images.githubusercontent.com/61551451/176135974-02bc1b01-b32e-4a54-bda1-c3094721f6fa.mov

Duration Cell

Five formats are supported in Duration Cell now!

image

Misc

  • Airtable import now has view import enabled by default
  • Health API - /api/v1/health
  • LTAR Rename
    • TableMMList => Table List (MM)
    • TableList => Table List (HM)
    • TableRead => Table (BT)
  • Support non-dbo schema in MSSQL
  • Bug fixes

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.91.10...0.92.0

0.91.10 6/15/2022

πŸš€ NocoDB : Bug Fix Release

Closed issue

  • [Scope : DevOps] update-sdk-path / release #2374
  • [Status: Resolved] 0.91.8 - Import Airtable to MariaDB not working - unauthorized access #2362
  • [Type: Bug][DB: MySQL][DB: Postgres][DB: SQLite][Status: Fixed] DateTimePicker not saved #2354
  • [Status: Resolved][DB: SQLite] Can't delete the table after import csv as DateTime with SQLite #2347
  • [Status: Resolved][Status: Reproducible] error importing CSV file ; can't access property "WBProps" e.wb.Workbook is undefined #2334
  • [Type: Bug][Status: Reproducible] Delete table error (with relational column) #2047

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.91.9...0.91.10

0.91.9 6/14/2022

πŸš€ NocoDB : Bug Fix Release

Closed issue

  • [Scope : DevOps] Invalid username or password in publish-docs #2352
  • [Status: Resolved] Columns not re-render when delete relational column #2344
  • [Type: Enhancement][Status: Resolved][Status: Reproducible] REST API JSON output limited to 1000 #2306
  • [Type: Bug][Status: Fixed][Status: Reproducible] Project Invite: Lost admin access to my project #2301
  • [Type: Bug][Status: Fixed][Status: Reproducible] Question mark is treated as a param in postgres' CONCAT #2294
  • [Type: Bug][Status: Fixed] password changing doesn't work (old password required) #2288
  • [Type: Bug][Status: Fixed][Status: Reproducible] Download CSV error with specific non-english table/column name #2286
  • [Status: Resolved] [i18n] Language support extension- #2268
  • [Status: Resolved] Who to contact for security issues #2262
  • [Type: Bug][DB: Postgres][Status: Fixed] Currency field fails for 'money' data type on PostgreSQL #2255
  • [Status: Fixed][Status: Reproducible] Date cell with invalid date cannot be changed anymore #2251
  • [Status: Fixed][Status: Reproducible] NocoDB can't display the values of a cell when it's of type LinkToAnotherRecord and has hundreds of connections #2242
  • [Type: Enhancement][Status: Resolved] Arrow keys not working properly when moving across the table fields #2240
  • [Status: Fixed] Shared Form view is Empty #2228
  • [Status: Fixed] Problem with API for Relation Rows #2208
  • [Status: Resolved] MSSQL Error on migration to 0.91.1 . #2201
  • [Status: Resolved][DB: SQLite] [decimal] datatype decimal accepts non-numeric characters #2106
  • [Status: Fixed][Type: In Development] [UIDT improvements] Rating/ checkbox as LTAR/ Lookup #2045
  • [Type: Bug][DB: SQLite][Status: Reproducible] 'Time' column in SQLite #1882

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.91.8...0.91.9

0.91.8 6/14/2022

πŸš€ NocoDB : Bug Fix Release

Closed issue

  • [closed] Issue: Something in nocodb code has changed that is causing use of v-treeview in nocodb gui to break #2321
  • [Type: Enhancement] Drag spreadsheet columns in Tables by mouse #2284
  • [closed] Docker-compose mysql not working #2282
  • [For: Community] More visible table borders to make it easier to read the table contents #2239
  • [Type: Bug][Status: Resolved][Priority: Critical] TypeError after upgrade to 0.91.6 with Docker #2225
  • [Scope : DevOps] npm issue in release #2223
  • [Status: More Info Needed][Type: AT Import] Import Airtable base to NocoDB (postgresql database) issue #2199
  • [Type: Feature] Turn essential apps credentials as env #2131
  • [Type: Bug][Status: Reproducible] [Formula] Validation missing in one of scenarios; additional records created #2046
  • [Type: Bug] Webhook error in postgres heroku for an user #1903

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.91.7...0.91.8

0.91.7 6/1/2022

NocoDB : Bug Fix Release

  • https://github.com/nocodb/nocodb/issues/2225 : TypeError after upgrade to 0.91.6 with Docker
  • [Status: Fixed] Webhook with condition has issues #2209
  • [Type: Bug][Status: Fixed] error:0909006C:PEM routines:get_name:no start line - for google cloud platform in heroku - Single slash to double slash issue #2207
  • [Status: Resolved][Type: In Development][Scope: UI / UX] UX: Scroll option for fields menu #2181
  • [Type: Enhancement][Status: Resolved][Scope: UI / UX] [UX] Search field option in filter & sort #2180
  • [Status: Fixed][Type: In Development][DB: All] formula field error when used in filter #2177
  • [Status: Resolved][Scope: UI / UX] [form view] disable update to number on scroll #2108
  • [Type: Bug][Status: Fixed][DB : MariaDB] DateTime causes error message in MariaDB docker #1048

0.91.6 6/1/2022

πŸš€ NocoDB : Bug Fix Release

Closed issue

  • [closed] Access denied for user 'root'@'localhost' #2210
  • [closed] package.json of nocodb-seed is not getting updated. #2203
  • [Status: Fixed] Shared grid view having a formula column results in an error #2176
  • [Status: Resolved][Type: AT Import] Import Airtable to Postgres database : type does not exist #2173
  • [Status: Resolved][Type: AT Import] Import Airtable to SQL database : schema imported but not the data #2172
  • [Status: Resolved][Type: AT Import] Import AirTable to SQL database : Missing 'rollup_function' property in request body #2171
  • [Status: Resolved] Enhancement : Show column icons within fields, sort, filter menus/dropdowns #2162
  • [Status: Resolved] Incomplete font changes and string overlaps for Persian language #2154
  • [Status: Resolved] When table is slow to load - show a loading status #2150
  • [Status: Resolved] Advanced options while importing : select lookup, rollup, formula, data. #2149
  • [Status: Resolved] [Feature] Create index for foreign keys created on postgres #2142
  • [Status: Resolved] CONCAT formula with URL fails. #2140
  • [Type: Bug][Status: Fixed] [formula] precedence to be considered in formula #2128
  • [Type: Bug][Status: Fixed][Type: AT Import] [Bug] Airtable import not working in Docker if mapped to a different port #2127
  • [Type: Bug][Status: Fixed][Priority: Low][Type: In Development][Scope: UI / UX] column name display text overflow in shared base #2088
  • [Status: Resolved][Type: In Development] [Import] SQL query mapping incorrect for multi-select #2058
  • [Type: Bug][Status: Fixed] Currency field- validation fails if decimal fractions are used #1647
  • [Type: Enhancement][Status: Fixed] [Feature] Currency Column Improvement #1352
  • [Type: Enhancement][Status: Fixed] Currency validator crashing when not adding two decimal places #1042
  • [Type: Enhancement][Status: Fixed] Currency fields always displayed with $ #572

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.91.1...0.91.6

0.91.1 5/27/2022

πŸš€ NocoDB : Enhancement Release : Import Airtable to SQL database

What's New

  • πŸš€ Import from Airtable to NocoDB Enhancement
  • πŸš€ Currency Enhancement
  • πŸš€ Formula Enhancement
  • πŸš€ Rating Enhancement
  • πŸš€ UI Enhancement
  • πŸš€ And we're hiring! πŸš€

Import from Airtable to NocoDB Enhancement

While importing Airtable to NocoDB, now users can have full flexibility to choose the major column types that they would like to import. Currently, data, rollup columns, lookup columns and attachment columns will be supported. Formula Columns will be supported in the future.

Screenshot 2022-05-27 at 4 39 11 PM

Currency Enhancement

We now support multiple currency locale and currency code (ISO 4217) and some validation logics have been also revised.

image

image | image | image |---|---|---|

Formula Enhancement

Handle NULL value when calling CONCAT

Previously any NULL value in formula with CONCAT would make the entire result empty. Now it's considered as an empty string instead.

Example: F: CONCAT({Title}, {Title1}, {Title2}, "B")

image

Include icons in formula suggestion list

image | image |---|---|

Misc

  • Show column options in suggestion list when users enter { as what's following must be a column.
  • Fix the incorrect insertAtCursor position when calling appendText. Previously selecting column1 after { would become {{column1} while {column1} is expected.
  • Fix incorrect ID passing to FormulaColumn.update. Previously deleting a column that is referenced by a formula would throw an error and all data will be not shown when calling dataList as something wrong with the cache part as attribute error is not updated due to the wrong ID.
  • Fix incorrect data type - e.g. ADD({numberic_formula}, 10) should be expected.
  • Fix formula precedence
  • Remove unexpected $pt.name$ - create a formula and edit it. {$column_name$} is shown rather than {column_name}.

Rating Enhancement

A custom color is now supported in a Rating column. You can select the predefined colors from our swatches or choose your desired one using a color picker in advanced settings. Manually inputting color is also supported with the format HEX, HSL and RGB.

image | image | image |---|---|---|

UI Enhancement

We've added transition for menus (filter / sort / fields) with icons within the menu items.

image | image |---|---|

image | image |---|---|

A loader is introduced for Grid & Gallery view when the data is being loaded.

https://user-images.githubusercontent.com/61551451/170499118-931e9ae6-e31a-48db-a6f5-f370edebae0c.mov

Closed Issues

  • [Status: Fixed][Priority: Low][Type: In Development] [shared base] hide webhook button in shared base #2107
  • [Status: Fixed][Type: In Development] gallery view- configured cover image not displayed #2099
  • [Status: Fixed][Type: In Development][Import] [import] with cache enable- sometimes during table data list, error observed referring to an non-existing column #2098
  • [Status: Fixed][Type: In Development][Import] [import] post import, data disappears from table on deleting column #2097
  • [Status: Resolved][Type: In Development][Import] [import] default value configuration throws error #2102
  • [Status: Resolved][Type: In Development][Import] [import] post import, grid view creation failed #2087
  • [Status: Resolved][Type: In Development][Import] [import] column skeleton persists in shared view after delete #2079
  • [Status: Resolved][Type: In Development][Import] [import / root db: sqlite] post import, column delete fails #2078
  • [Status: Resolved] Can't import XLSX - /dashboard/?q=sqlOp_projectCreateByWebWithXCDB 404 #2005
  • [Status: Resolved] implement exist API in v2 #2064
  • [Status: Resolved] Problem with SingleSelect Column #2059
  • [Status: Resolved] [i18n] Language Improve - #2049
  • [Status: Resolved][Status: Fixed] Unable to upload .xlsx file #1851
  • [Status: Resolved][Status: Fixed] Changing the Persian strings' font in NocoDB interface #1610
  • [Status: Fixed][Type: In Development] [UIDT improvements] validation #2038
  • [Status: Fixed][Type: In Development] [UIDT-improvements] Rating field error on inserting record #2036
  • [Type: Bug][Status: Resolved] failed to create columns in tables with whitespaces at the end #2073
  • [Type: Bug][Status: Fixed][Status: Reproducible] Send ID with DELETE webhook? #2024
  • [Type: Bug][Status: Fixed] Nested fields query param does not respect '*' to include all fields #1981
  • [Type: Bug][Status: Fixed][Status: Reproducible] Formula fields throw an error when referencing fields that start with a number #1964
  • [Type: Bug][DB: Postgres][DB: SQLite][DB: MSSQL][Status: Fixed][Status: Reproducible] Single select issues (reported in discord) #1955
  • [Type: Bug][DB: Postgres][Status: Fixed][Status: Reproducible] Can't change the type of the default column "title" #1949

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.91.0...0.91.1

Join Our Team

0.91.0 5/23/2022

πŸš€ NocoDB : Feature Release : Import Airtable to NocoDB

Screenshot 2022-05-23 at 11 23 23

What's New :

  • πŸš€ Import Airtable to NocoDB
  • πŸš€ Import CSVs, Excel to NocoDB
  • πŸš€ New APIs : GroupBy and Exists
  • πŸš€ Column improvements : Ratings
  • πŸš€ Formula enhancements
  • πŸš€ And we're hiring! πŸš€

Import Airtable to NocoDB

Now within a minute or two import all your Airtable bases to any MySQL, Postgres, SQL server or SQLite databases using NocoDB!

https://user-images.githubusercontent.com/61551451/169801882-b36c7b79-a29d-40ad-bbf5-5807b9cf611c.mov

See Documentation - Import Airtable to NocoDB for details.

Import from CSV

We support users to import CSV data to an existing project.

See Documentation - Import CSV data into an existing project for details.

image

Import from Excel

We support users to import Excel data to an existing project. If an Excel file includes multiple sheets, they will be considered as different tables and users can manipulate the meta before the actual import.

See Documentation - Import Excel data into an existing project for details.

image

New APIs

We've introduced two new APIs - exist & groupby.

Exist

Exist API allows users to check if the row with provided primary key(s) exists or not. The result would be either true or false.

For table row,

curl --request GET \
--url 'http://localhost:8080/api/v1/db/data/<org>/<projectName>/<tableName>/<ID>/exist' \
--header 'xc-auth: <REDACTED>'

For table view,

curl --request GET \
--url 'http://localhost:8080/api/v1/db/data/<org>/<projectName>/<tableName>/views/<viewName>/<ID>/exist' \
--header 'xc-auth: <REDACTED>'

GroupBy

Given a column name, return the number of records in each group.

For table row,

curl --request GET \
--url 'http://localhost:8080/api/v1/db/data/{orgs}/{projectName}/{tableName}/groupby?column_name=<COLUMN_NAME>' \
--header 'xc-auth: <REDACTED>'

For table view,

curl --request GET \
--url 'http://localhost:8080/api/v1/db/data/{orgs}/{projectName}/{tableName}/views/{viewName}/groupby?column_name=<COLUMN_NAME>' \
--header 'xc-auth: <REDACTED>'

Rating

Rating allows users to rate based on a comparative assessment with maximum rating allowed from 1 to 10. Users may change the rating symbol and color as well.

image

image image
image image

Formula enhancements

  • Add information message when double clicking formula cell and add help text by hovering the function name

    image | image |---|---|

  • Add circular reference detection. Example: formula1 -> formula2 -> formula3 -> formula4 ("HELLO").

image | image |---|---|

  • Improve formula argument validations

image | image |---|---|

Closed Issues

  • [Status: Fixed][Type: In Development] [quick import] form view drag & drop opens up import modal #2044
  • [Status: Fixed][Type: In Development] [quick import] shared base view mode - displays add table header #2043
  • [closed] Feature request : Enforced primary key should be selectable non-integer #2006
  • [Type: Bug][DB: All] DateTime value not saved #1978
  • [Status: More Info Needed][Status: Fixed] Synologoy NAS : the 0.90.10 docker container crash #1970
  • [Type: Enhancement][Status: Need Internal Discussion] Query parameter to limit fields in returned relations [Feature] #1763

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.90.11...0.91.0

Join Our Team

0.90.11 5/4/2022

πŸš€ NocoDB : Bug Fix Release

Closed issue

0.90.10 5/4/2022

πŸš€ NocoDB : Bug Fix Release

What's New

Code Snippet is introduced in this version where you can find different sample code snippets for List API for reference.

image

Closed Issues

  • [Type: Bug][Status: Fixed][Status: Reproducible] Change a role from editor -> creator. User is not able to create table. #1959
  • [Type: Bug][Status: Fixed][Type: In Development][Status: Reproducible] [Nested lookup] Lookup on a Lookup show empty record #1946
  • [Type: Bug][Status: Fixed][Type: In Development][Status: Reproducible] Unable to delete table with Self m2m link #1945
  • [closed] Table names in postgres get the project id as prefix #1942
  • [Type: Bug][Status: Fixed][Status: Reproducible] Dialog containing monaco editor closes on click #1932
  • [Type: Bug][Status: Fixed] meta database tables shown in UI #1910
  • [Status: More Info Needed][Status: Fixed] XC Swager UI fails to load in local docker container #1900
  • [Type: Bug][Status: Fixed] Swager API doc shows endpoints from all projects #1899
  • [Type: Bug][Status: Fixed] Inconsistent response for deprecated URL paths #1895
  • [Type: Bug][DB: Postgres][Status: Fixed] PG Formula issue #1873
  • [Status: Fixed] Lookup columns used in filters and formulas cause errors #1866
  • [Type: Bug][DB: Postgres][Status: Fixed] DATEADD function interval argument issue #1865
  • [Type: Bug][Status: Fixed] Number and date calculation fail to render in UI #1864
  • [Type: Bug] Issue in deleting related tables #1861
  • [Priority: Critical][Type: 0.90 Migration] Migration error from 0.84.16 to 0.90.7 for sqlite3 database #1847
  • [Type: Bug][Status: Fixed] List API failing if child table has a JSON column #1835
  • [Type: Bug][Status: Fixed] error 400 when upload to S3 #1822
  • [Status: Fixed][Scope: UI / UX] Table alias in tooltip for relational columns should not be shown #1880
  • [Status: Fixed][Scope: UI / UX] Styling issue with Team & Settings modal #1793
  • [Status: Fixed][Type: 0.90 Migration] Migration from 0.84.16 to 0.90.4 failed (mssql, docker) #1790
  • [Status: Fixed][Priority: Critical] Existing sqlite is not working #1956
  • [Status: Resolved][DB: Postgres][Status: Reproducible] Can't create a new column with PK option #1947
  • [Status: Resolved][Scope : DevOps] [Feature] Single click end to end release action #1776
  • [Status: Resolved][Scope: UI / UX] multiple LTAR to same table- not distinguishable in UI #1811
  • [Type: Feature][Status: Resolved] [Feature] Use column name in lookup instead of table/relation type #1768
  • [For: Community] Cannot change the column to SingleLineText to LongText #1930
  • [Type: Enhancement][Status: Resolved][Scope : DevOps] Update nocodb-sdk to local path after release #1925
  • [closed] Failed to Update csv file - 400 #1918
  • [closed] cannot import excel spreadsheets on v0.90.8 #1915
  • [closed] Specified key was too long; max key length is 1000 bytes #1883
  • [closed] System fields not being appropriately marked for linked records on Postgres #1754

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.90.8...0.90.10

0.90.8 4/28/2022

πŸš€ NocoDB : Bug Fix Release

Closed Issues

  • [Type: Bug][Status: Fixed] Swagger docs shows localhost by default #1843
  • [Type: Bug] Roll up the formula column failed and make all rows cannot be accessed #1842
  • [Type: Bug][Status: Fixed] JSON type data is not getting saved from UI #1814
  • [Type: Bug][Status: More Info Needed] Multiple lookup columns in one table result in malfunction #1799
  • [Type: Bug][Status: Fixed] 'fields' query parameter in REST API has no effect #1762
  • [closed] Formula columns on heroku not showing results. #1868
  • [closed] data inserted vice versa (nocodb and with python mysqli script) is not inserted on other side #1862
  • [closed] Migration from 0084002 to 0090000 (sqlserver) #1855
  • [closed] Version 0.84.18 ? #1850
  • [closed] FindOne API #1827
  • [Type: Feature][Status: Fixed] Provide swagger docs for each project #1769

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.90.7...0.90.8

0.90.7 4/23/2022

πŸš€ NocoDB : Bug Fix Release

Closed Issues

  • [Type: Bug][Status: Fixed] Unreachable previous API paths after upgrade #1831
  • [Type: Bug][Status: Fixed] Forget Password #1828
  • [Type: Bug][Status: Fixed] 'change password' does not take effect #1824
  • [Type: Bug][Status: Fixed] error 400 when upload to S3 #1822
  • [Type: Bug][Status: Fixed] Anyone encountered data not properly saving in UI? #1813
  • [Type: Bug][Status: Fixed] fatal: unsafe repository ('/github/workspace' is owned by someone else) #1785
  • [Type: Bug][Status: Fixed] Invalid requests by search field in NocoDB UI #1784
  • [Type: Bug][Status: Fixed] Enter not properly captured when in edit form for linked record column name #1781
  • [Type: Bug][Status: Fixed] Color code for HasMany, ManyToMany, Lookup and Rollup #1766
  • [Type: Bug][Status: Fixed][Type: 0.90 Migration] schema immediately out of sync on postgres when creating table, columns #1753
  • [Type: Bug][Status: Fixed] SMTP app doesn't work in 0.90.3 #1751
  • [Type: Bug][Priority: Critical] Error upgrading 0.84.16 -> 0.90.2 on heroku using command line #1736
  • [Type: Bug][DB: SQLite] Failed to create column with datatype 'Time' #1380
  • [Type: Bug][Scope: v0.90.0] Tables connected by a natural id (a foreign key that is not the primary key on the other side) are not viewed properly #1299
  • [Type: Bug] Populating a column with link to another record doesnt work on an empty row #1284
  • [Type: Bug][Type: Enhancement][Scope: v0.90.0] Multiple foreign keys to same tables results in issues. #756
  • [Type: Bug][Status: Fixed] Unable to Upload Attachments using shared base link #1579
  • [Type: Enhancement][Scope: v0.90.0] Missing WHERE clause in Bulk APIs #1421
  • [Type: Question] App configuration #1563
  • [i18n translation] [i18n] Language support extension- #1420
  • [Type: Feature] [Feature] Allow filtering on "LinkToAnotherRecord" field #868
  • [Status: More Info Needed] Wrong page change widget #818
  • [Type: Feature] Client SDKs #575
  • [Type: Enhancement][Scope: v0.90.0] Shared View GET API #442
  • [Type: 0.90 Migration] My user is suddenly missing #1794
  • [Type: Feature][Status: Fixed] [Feature] The Editor need the function of ”Upload CSVβ€œ #1683
  • [Status: Fixed] DATEADD formula issues #1638
  • [Status: More Info Needed] Cell won't update properly in version 0.84.16 #1637
  • [Status: More Info Needed] Dashboard loading too long #1545
  • [Status: More Info Needed] [Cannot read property 'meta' of undefined] When create table #1452
  • [Status: More Info Needed] Webhook doesn't work on API inserted row #1440
  • [Status: Fixed][Type: In Development] able to clear record for locked view (from both normal grid & editor mode shared base) #1773
  • [Status: Fixed][Type: In Development] form view shows roll-up column #1772
  • [closed] Only owner can use ”Upload CSVβ€œ when updated to PackageVersion: 0.90.5 #1810
  • [closed] [Feature] #1786
  • [i18n translation] [i18n] Language support extension- ja #1680
  • [For: Community][Status: Fixed][minor] Enable scroll for sort & filter #1675
  • [For: Community][minor] [minor] LTAR - UI improvement #1673

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.90.5...0.90.7

0.90.5 4/19/2022

πŸš€ NocoDB : Bug Fix Release

Closed Issues

  • [Type: Bug][DB: MSSQL][Status: Fixed] Migration from 0.84.16 to 0.90.3 failed (mssql, docker) #1764
  • [Type: Bug][Status: Fixed][Priority: Critical] Migration errors to 0.90.3 #1760
  • [closed] Search Columns & Filter feature do not work with non english title columns. #1758
  • [Type: Bug][Status: Fixed] Filter doesn't return correct results on linked record #1756
  • [i18n translation] [i18n] Language support extension- zh-CN #1744
  • [Type: Bug][Status: Fixed] SMTP app bug #1743
  • [closed] Wrong version number #1742
  • [Type: Bug][Status: Fixed] Failed to import CSV #1737

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.90.4...0.90.5

0.90.3 4/18/2022

πŸš€ NocoDB : Bug Fix Release

Closed Issues

  • [closed] Migration from 0084002 to 0090000 failed (mssql, docker) #1741
  • [Type: Bug][Status: Fixed][Priority: Critical] Can't access projects since upgrade to 0.90.0 #1722
  • [Status: Fixed] shared base- fields showAll/ HideAll error #1713

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.90.2...0.90.3

0.90.2 4/17/2022

πŸš€ NocoDB : Bug Fix Release

Updates

Updated audit migration code to extract the correct model id on migration.

Closed Issues

  • [Status: Fixed] + 0.90.1 release #1725

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.90.1...0.90.2

0.90.1 4/17/2022

πŸš€ NocoDB : Bug Fix Release

Updates

Made corrections in old project migrations to exclude deleted project audit logs.

Closed Issues

  • [Scope: v0.90.0] Failed to exec filter request with a non-english column #1593
  • [Type: Feature][Scope: v0.90.0] [Feature] search / sort / filter on the primary value of linked records #1522
  • [Type: Feature][Scope: v0.90.0] [Feature] Automate creation of tables (via Rest API / JSON / Yaml...) #1430
  • [i18n translation][Scope: v0.90.0] Adding Farsi to NocoDB interface #1321
  • [Type: Enhancement][Scope: v0.90.0] Column re-order doesn't work on Postgres Views #1319
  • [Type: Feature][Scope: v0.90.0] [Feature] Use rollup column in Formula #514
  • [Type: Feature][Scope: v0.90.0] [Feature] Use Lookup column in Formula #512
  • [Type: Feature][Scope: v0.90.0] [Feature] Order of many to many relations #511
  • [Type: Feature][Scope: v0.90.0] Feature : Meta APIs #457
  • [Type: Enhancement][For: Community][Scope: v0.90.0] Feature: Allow sorting/filtering using lookup columns #444
  • [Type: Enhancement][Scope: v0.90.0] Feature: Allow lookup on grandparent tables #443
  • [Type: Feature][Scope: v0.90.0] API to views #253

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.90.0...0.90.1

0.90.0 4/16/2022

πŸš€ NocoDB : v0.90.0 : Nested lookups + NocoDB SDK

We are really glad to announce that nocodb v0.90.0 has been released.

This release includes some breaking changes (as communicated before - see here) and some notable new features shown below.

What's New in v0.90.0?

  • API Design (Auth / Public / Data / Meta)
  • NocoDB SDK
  • Support Nested Lookup
  • Support Sort on Lookup, Formula, Nested Data
  • Support Filter on Lookup, Rollup, Formula, Nested Data
  • Support Formula with Lookup, Rollup, Column
  • Support Duplicate Relation
  • API Documentation
  • Community Forum

Migration

The migration for meta data will be done automatically. In case you wish to rollback to previous version, you may simply downgrade it to the target version.

Closed Issues

  • [Status: Fixed][Type: In Development] relation update in editor mode fail #1706
  • [Status: Fixed][Type: In Development] link to record using pop up "add row" modal - does not work #1696
  • [Status: Fixed][Type: In Development] hmList- error on removing linked record #1695
  • [Status: Fixed][Type: In Development] Project info access fails in commenter/ viewer mode #1694
  • [Status: Fixed][Type: In Development] Expanded card (hmList) is empty for relational column in Commenter/ Viewer mode #1693
  • [Status: Fixed][Type: In Development] XCDB migration- displays incorrect meta-sync data #1692
  • [Status: Fixed][Type: In Development] Form view- error on configuring title #1688
  • [Status: Fixed][Type: In Development] xc-token is not allowing to do write operation #1684
  • [Status: Fixed][Type: In Development] external db- toast doesn't disappear on attempt to create project with existing name #1669
  • [Status: Fixed][Type: In Development] Virtual columns not mapped appropriately #1663
  • [Status: Fixed][Type: In Development] Editor role- download CSV not allowed #1662
  • [Status: Fixed][Type: In Development] shared grid view- column operations (hide/sort/filter) have no impact on download CSV #1660
  • [Status: Fixed][Type: In Development] webhook create with filter condition - failure #1657
  • [Status: Fixed][Type: In Development] delete record- failure #1656
  • [Status: Fixed][Type: In Development] shared view- download failure #1655
  • [Status: Fixed][Type: In Development] Additional field option displayed in shared grid view #1654
  • [Status: Fixed][Type: In Development] rename view- active screen toggles to default view #1653
  • [Status: Fixed][Type: In Development] Incorrect migration of UI ACL #1622
  • [Status: Fixed][Type: In Development] Error: Fields - Hide all #1615
  • [Status: Fixed] Browser logging many informations #1611
  • [Status: Fixed][Type: In Development] LastUpdate should be auto generated but it requires users to input in Form view only #1652
  • [Status: Fixed][Type: In Development] Empty grid after table creation #1651
  • [Status: Fixed][Type: In Development] Additional column displayed in actor table/ category table #1650
  • [Status: Fixed][Type: In Development] shared form view- error while fetching linked records #1649
  • [Status: Fixed][Type: In Development] table create- project tree records not updated #1648
  • [Status: Fixed] Notification gets in the way of column headers #1646
  • [Status: Fixed] DATEADD formula issues #1638
  • [For: Community] Can't kill docker app with sigint #1661
  • [closed] I can't change the default port 8080 to a custom value #1617
  • [Type: In Development] Notify about v0.90 changes as announcement in app bar #1691
  • [Type: In Development] Hide row counter for timebeing #1644
  • [Type: In Development] set as primary value - permission error #1658
  • [Type: In Development] *List & *Read Column Deletion Failure #1659
  • [Type: Bug][Status: Fixed] Error when editing a SingleSelect column #1597
  • [Type: Bug][Status: Fixed] Unable to create SingleSelect with type anyenum #1539
  • [Type: Bug][Status: Fixed] CSV import fail with NULL value #1537
  • [Type: Bug][Status: Fixed] [Discord] Multiple attachment- icon overlaps & extends beyond cell limit boundaries #1468
  • [Type: Bug][Status: Fixed] Changing single select fields results in webhooks getting called twice #1312
  • [Type: Bug][Status: Fixed] Multiselect bug with comma #1282
  • [Type: Bug][Status: Fixed] Multiselect on pg is leading to an error #1630

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.84.16...0.90.0

Thank you

We would like to thank all the users and contributors to join the journey with us. If you have any questions, please feel free to post your questions to Discord. If you are interested to contribute, please check out Contribution Guide.

0.84.16 4/6/2022

πŸš€ NocoDB : Bug Fix Release

Important Announcement

Closed Issues

  • [closed] Repository Description should include SQLite #1588
  • [closed] Webhook bug: CSV import does not touch off the insert/update trigger. #1581
  • [Status: Resolved][i18n translation] [i18n] Language support extension- #1533
  • [i18n translation] [i18n] Language support extension- es #1513
  • [i18n translation] [i18n] Language support extension-nl #1467
  • [i18n translation] [i18n] Language support extension- ru #1460
  • [i18n translation] [i18n] Language support extension- #1455
  • [Type: Bug][Status: Fixed] multiple after-update webhooks being triggered when changing value in SingleLineText / LongText #1453
  • [Type: Bug][Status: Fixed] /distinct Rest API endpoint throws error for table with json columns |PG| #1422
  • [Status: Resolved][i18n translation] [i18n] Language support extension- lv #1405
  • [Status: Resolved][i18n translation] [i18n] Language support extension- fr #1398
  • [closed] Knex: Timeout acquiring a connection. The pool is probably full when creating project with a lot of tables (260 in my case) #1150
  • [Type: Enhancement] [Feature] Simplify release #1139

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.84.15...0.84.16

0.84.15 3/14/2022

πŸš€ NocoDB : Bug Fix Release

Closed Issues

  • [closed] SingleSelect in Column Type Can't Add option #1423
  • [closed] [Feature] Better copy pasting from NocoDB #1419
  • [closed] [Feature] Choose how many rows to show on each page. #1418
  • [closed] Where are attachment file stored ? #1416
  • [closed] Deleting of user not possible #1399
  • [closed] No Access to any project using API Key #1344
  • [closed] utf8mb4 character set instead of utf8 #1340
  • [Type: Bug][Status: Fixed] Text doesn't show up in Swagger Form for POST requests body #1367
  • [Status: More Info Needed] Webhooks are being executed twice #1312
  • [Status: Won't Fix] it's maybe to easy to delete rows #1388
  • [Status: Won't Fix] Cannot input the Chinese characters in the table #1294
  • [Status: Resolved] The Datetime column will increase by 8 hours and must be saved repeatedly to save successfully #1293
  • [Status: More Info Needed] Many-Many relationships don't populate in form/expanded view #971
  • [Status: More Info Needed] Could not parse JSON #945
  • [closed] docker run with mysql error #771
  • [Type: Enhancement] [Feature] Add total number of records in current table/filter/view #680
  • [Type: Enhancement][For: Community] Enhancement: Move views panel to left below table #624
  • [Status: More Info Needed] Bug: failed to restore database from a snapshot #541
  • [Status: More Info Needed] NoCobd Error - TypeError: Cannot read properties of undefined (reading 'data') #522
  • [Type: Enhancement][Type: Feature] Feature : Full import/export/backup feature? - docker nocodb #384
  • [Type: Feature] Feature : Metadata sync #330
  • [Type: Feature] Formula should support date arithmetic #1389

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.84.14...0.84.15

0.84.14 2/24/2022

πŸš€ NocoDB : Bug Fix Release

Closed Issues

  • [Type: Bug][Status: Resolved][Priority: Critical] Can't reset password #1337
  • [Type: Bug] formula not working as long as capital letter(s) exist in column name #1332
  • [i18n translation] Couldn't find the local language code (Farsi) in the provided google workspace list #1320
  • [Status: Resolved] Error " request failed with status code 400 " raised when trying to import an Excel file #1313

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.84.12...0.84.14

0.84.12 2/17/2022

πŸš€ NocoDB : Bug Fix Release

Closed Issues

  • [Type: Bug][Status: Fixed] [UI] Add row options disappears #1151
  • [Type: Bug][Status: Resolved] Cannot POST row to table #1146
  • [Type: Enhancement] Document i18n process #1145
  • [Type: Bug][DB: Postgres][Status: Fixed][Priority: Critical] Postgres : SingleSelect/Multiselect isn't working in 0.84.9 #1132
  • [DB: Postgres][Status: Fixed][Priority: Critical] Cannot add Percentage as a column #1129
  • [Type: Bug][Status: Fixed][Priority: Critical] Refreshing SQL Views returns blank page #1126
  • [Type: Bug][DB: Postgres][Status: Fixed][Priority: Critical] uuid data type not working in searches in postgres #996
  • [Type: Bug][Type: Enhancement][Status: Fixed][Priority: Critical] View does not has action type for downloading csv file as table does. However the shared view link does. #991
  • [Type: Bug][Status: Fixed] Upload CSV Import Error #880
  • [Type: Bug][Status: Fixed][Priority: Critical] Link to another record doesn't always populate possible options #781
  • [Type: Bug][Priority: Critical] Rename a table which as a space - it leads to an error #768
  • [Type: Bug][Status: Fixed][Priority: Critical] Search not working on bigint fields #589
  • [Type: Bug][Status: Resolved] Issue: Setting default value involving symbols or multiline gives errors when setting default value for longtext #539
  • [Type: Bug][Status: Fixed][Priority: Critical][Status: Action Needed] Whitespace in tablename while creating m2m relation leads to column not being shown. #479
  • [Type: Bug] Cannot Add/Edit record properly when table has composite keys #297
  • [Type: Bug] Bug: Unable to drop column of a composite primary key in Postgres #234

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.84.10...0.84.12

0.84.10 2/9/2022

πŸš€ NocoDB : Bug fix release

Closed Issues

  • [Type: Bug] Multiple id columns are shown when there is only 1 id column in the table. #806
  • [Type: Bug][For: Community][For: Hacktoberfest] Using create time field leads to error in updating table #558
  • [Type: Bug] Cannot add Percentage as a column #1129
  • [Type: Bug][DB: Postgres][Priority: Critical] Postgres : SingleSelect/Multiselect isn't working in 0.84.9 #1132
  • [Type: Bug][Priority: Critical] Refreshing SQL Views returns blank page #1126

What's Changed

Full Changelog: https://github.com/nocodb/nocodb/compare/0.84.9...0.84.10

0.84.9 2/7/2022

πŸš€ NocoDB : Bug Fix Release

Closed Issues

  • [Priority: Critical] Sync shows schema changes for the changes done via GUI #1049
  • [closed] Formulas Not Calculating after latest release #1047
  • [closed] Lookup on "Formula field" not available - bug or just normal? #1045
  • [Type: Bug][Status: Fixed][Priority: Critical] Webhook to send email notification can't be cancelled #1034
  • [Type: Bug][DB: MSSQL][Status: Fixed][Priority: Critical] Update table failed - renaming column and changing field length #1018
  • [closed] Incorrect row counts and missing pagination #1013
  • [closed] how use REST APIs Upload single file #1008
  • [Type: Bug][Status: Fixed][Priority: Critical] Preview has some part of UI parts obscured #993
  • [Type: Bug][Status: Fixed][Priority: Critical] Different date view in gridview and galleryview #992
  • [Type: Feature] [Feature] Support for readonly views and editable views #835
  • [closed] Follow Production setup got an error: Malformed UTF-8 data #829
  • [Type: Bug][Status: Fixed][Priority: Critical] Inserting new row with not null fields in grid view doesn't works #828
  • [Status: Resolved] End of table name has a space will cause insert error #825
  • [Status: Resolved] Not a valid syntax - Error when filtering columns with column names containing "-" #690

What's Changed

New Contributors

Full Changelog: https://github.com/nocodb/nocodb/compare/0.84.8...0.84.9