0.107.1: Bug Fix Release

🚀 NocoDB : Bug Fix Release

🐛 Closed Issues

• [closed] 🐛 Bug: after updated (docker) to 0.107.0 I get multiple errors #5679
• [closed] 🐛 Bug: not reading environment variables #5673

What's Changed

• Release 0.107.0 by @github-actions in #5672
• test: remove PW flakyness - undo-redo, attachment, select column by @dstala in #5674
• fix: Load JWT secret from store on app init by @pranavxc in #5680
• fix: Read env file on app app load by @pranavxc in #5685
• 0.107.1 Pre-release by @github-actions in #5686

Full Changelog: 0.107.0...0.107.1

0.107.0

🚀 NocoDB Feature Release : Copy Projects / Tables 🚀

🥬 What's new .. What's fresh ?

Copy Projects / Tables

We are stoked to introduce much asked features of Project Copy and Table Copy features - your ticket to seamless productivity!

💡Ever find yourself thinking, "I wish I could just duplicate this entire project or table"? Well, now you can! Imagine the possibilities! With just a SINGLE CLICK, you can clone your carefully crafted projects or tables, effectively bypassing the monotonous chore of recreating similar tasks or items. It's like having a digital twin at your disposal - just more efficient and less sci-fi!

📈 But it doesn't stop there! Enjoy complete control over what you copy, including all views or data and more. Each element of your projects or tables is duplicated in exquisite detail. No more missing links, no more errors in transcription. Your workflows will be cleaner, your collaborations smoother, and your efficiency off the charts!

🚀 With NocoDB's Project Copy and Table Copy features, you're not just duplicating data; you're replicating productivity. Carry forward all those lessons learned, those meticulously crafted structures, and those collaborative notes, enabling you to hit the ground running with new projects!

239493151-adeeede9-0580-4bf2-a4ad-6b7bc313e638.mov

239493103-08b8d7a7-66a2-429f-9924-9c11b679eb81.mov

PS : This feature is available when project is on root-db and not on external DB.

Coming soon!

GeoData + Map View ( Sneak peak )

The new feature launch includes beta access for GeoData column and Map View. With this, users can easily input and view location data associated with their records, making it easier to analyse and interpret data based on geography. The Map View feature allows users to visualise their data on an interactive map. Users can filter their data by location, zoom in and out. Overall, the GeoData column and Map View feature provides powerful tool that adds a new dimension to data analysis, providing users with an intuitive and visually engaging way to explore and interpret their data.

Mobile mode (Sneak peak )

A toggle button is now available in beta access, which enabled will

• helps simplify UI layout for mobile view.
• enable's QR scan option to retrieve a stored record.

Note that, Sneak peak features are work in progress & needs to be explicitly enabled using easter egg menu. Please get in touch with us for more details.

Join Our Team

Thank you for your love & support

💜 🚀

---

🐛 Closed Issues

• [closed] 🔦 Feature: Is the backend source code of the nocodb project open source now? How can I obtain the backend source code #5668
• [Status: Reproducible] 🐛 Bug: DATEADD with negative offset #5644
• [🐛 Type: Bug][Status: Reproducible] 🐛 Bug: Nested group filter error while creation #5639
• [🐛 Type: Bug][Status: Reproducible] 🐛 Bug: Help text missing in shared form view #5633
• [Status: Reproducible] 🐛 Bug: Filter dropdown for select fields disabled #5632
• [🔎 Status: More Info Needed] Issue: Shared base UX & permissions #5630
• [closed] 🐛 Bug: no connection to a Postgresql DB in a docker #5616
• [closed] 🐛 Bug: Currency datatype, cell with value 0 displayed as empty cell #5607
• [🐛 Type: Bug] 🐛 Bug: Google Cloud Storage Plugin Private Key exceeds character limit #5606
• [closed] [Feature] Version Control on Rows #5589
• [closed] 🐛 Bug: Gallery shared view doesn't show LTAR #5561
• [closed] 🐛 Bug: nocodb-nest: error during init if database is not created already #5549
• [closed] 🐛 Bug: Messy interface after the upgrade to v0.106.1 #5548
• [closed] 🐛 Bug: Email plugin is not found after upgrade #5543
• [closed] About licence of plugin #5542
• [closed] 🐛 Bug: import csv data : you mixed columns and rows #5529
• [closed] delete this please #5521
• [closed] 🐛 Bug: npm run watch:run command failed to execute #5520
• [🐛 Type: Bug] 🐛 Bug: Exporting the table as CSV does not export the ID for link records #5514
• [closed] 🔦 Feature: Allow customizing webhook body #5511
• [closed] 🐛 Bug: API filtering a date field as "is not null" gets a 500 #5507
• [closed] 🐛 Bug: .jpg and .jpeg can't be attached / iphone can't attach image or file #5499
• [Status: Reproducible] 🐛 Bug: Date filters flawed work in DateTime columns #5483
• [✨ Type: Enhancement] enhancement: add scrollbar in column list #5482
• [🐛 Type: Bug] 🐛 Bug: Primary column shows red border #5424
• [closed] 🐛 Bug: Previous page data for empty cells #5372
• [closed] 🐛 Bug: Edit Host Address in Database Connections fails #5313
• [🐛 Type: Bug] 🐛 Bug: Failed to fetch dynamically error #5266
• [closed] 🔦 Feature: Confirmation on delete record #5263
• [closed] 🔦 Feature: Optimize formulas in SQL queries #5160
• [closed] Bug: Migration failure #5034
• [🔦 Type: Feature][🔭 Scope : Project] [Feature] Apps Script Code Snippet #2477
• [🔦 Type: Feature][🔭 Scope : Project] Docs : Give examples for API request/response #2437

What's Changed

• Release 0.106.1 by @github-actions in #5501
• fix(nocodb): extract pv object by @wingkwong in #5504
• feat: cache on list sync by @wingkwong in #5502
• fix(nc-gui): datetime filters by @wingkwong in #5498
• Moving backend to nestjs by @pranavxc in #5444
• New Crowdin updates by @o1lab in #5519
• chore(deps): bump vm2 from 3.9.16 to 3.9.17 in /packages/nocodb by @dependabot in #5515
• chore(deps): bump yaml and @commitlint/load in /packages/nc-plugin by @dependabot in #5535
• chore(deps): bump yaml from 2.1.3 to 2.2.2 in /tests/playwright by @dependabot in #5534
• chore(deps): bump vm2 from 3.9.16 to 3.9.17 in /packages/nocodb-nest by @dependabot in #5516
• fix(nc-gui): retrieve the comment part from the audit description by @wingkwong in #5513
• New Crowdin updates by @o1lab in #5538
• fix(nocodb): allow kanban for calling publicHmList and publicMmList by @wingkwong in #5536
• 🔦 Feature: Confirmation on delete record by @gitstart in #5419
• test: sync optimisation changes by @dstala in #5537
• New Crowdin updates by @o1lab in #5563
• feat: add description field to meta tables by @pranavxc in #5540
• add mysql to helm chart by @sgeist-ionos in #5162
• fix: create meta db if missing by @pranavxc in #5566
• fix(nc-gui): input focus in expanded form by @wingkwong in #5539
• Github action changes for deploying nestjs backend by @pranavxc in #5510
• feat: webhook body edit by @wingkwong in #5530
• fix: api-token strategy correction by @pranavxc in https://github.com/noco...

0.107.0-beta.1

🐛 Closed Issues

• [closed] 🐛 Bug: Currency datatype, cell with value 0 displayed as empty cell #5607
• [closed] [Feature] Version Control on Rows #5589
• [🐛 Type: Bug] 🐛 Bug: Exporting the table as CSV does not export the ID for link records #5514
• [✨ Type: Enhancement] enhancement: add scrollbar in column list #5482

What's Changed

• Release 0.107.0-beta.0 by @github-actions in #5588
• New Crowdin updates by @o1lab in #5591
• New Crowdin updates by @o1lab in #5598
• chore(deps): bump engine.io from 6.2.1 to 6.4.2 in /packages/nocodb by @dependabot in #5574
• enhancement: add scrollbar in column list by @gitstart in #5586
• fix(nc-gui): currency field by @wingkwong in #5614
• feat: Use event emitter for webook by @pranavxc in #5597
• fix: validate and sanitise column default value to avoid sql injection by @pranavxc in #5613
• fix: drop mm table on column delete by @mertmit in #5609
• fix(nocodb): incorrect LTAR record ID in exported file by @wingkwong in #5578
• feat: duplicate project and table by @mertmit in #5608
• New Crowdin updates by @o1lab in #5620
• 0.107.0-beta.1 Pre-release by @github-actions in #5621

Full Changelog: 0.107.0-beta.0...0.107.0-beta.1

0.107.0-beta.0

🐛 Closed Issues

• [closed] 🐛 Bug: Gallery shared view doesn't show LTAR #5561
• [closed] 🐛 Bug: nocodb-nest: error during init if database is not created already #5549
• [closed] 🐛 Bug: Messy interface after the upgrade to v0.106.1 #5548
• [closed] 🐛 Bug: Email plugin is not found after upgrade #5543
• [closed] 🐛 Bug: import csv data : you mixed columns and rows #5529
• [closed] delete this please #5521
• [closed] 🐛 Bug: npm run watch:run command failed to execute #5520
• [closed] 🔦 Feature: Allow customizing webhook body #5511
• [closed] 🐛 Bug: API filtering a date field as "is not null" gets a 500 #5507
• [closed] 🐛 Bug: .jpg and .jpeg can't be attached / iphone can't attach image or file #5499
• [Status: Reproducible] 🐛 Bug: Date filters flawed work in DateTime columns #5483
• [🐛 Type: Bug] 🐛 Bug: Primary column shows red border #5424
• [closed] 🐛 Bug: Previous page data for empty cells #5372
• [closed] 🐛 Bug: Edit Host Address in Database Connections fails #5313
• [🐛 Type: Bug] 🐛 Bug: Failed to fetch dynamically error #5266
• [closed] 🔦 Feature: Confirmation on delete record #5263
• [closed] 🔦 Feature: Optimize formulas in SQL queries #5160
• [closed] Bug: Migration failure #5034
• [🔦 Type: Feature][🔭 Scope : Project] Docs : Give examples for API request/response #2437

What's Changed

• Release 0.106.1 by @github-actions in #5501
• fix(nocodb): extract pv object by @wingkwong in #5504
• feat: cache on list sync by @wingkwong in #5502
• fix(nc-gui): datetime filters by @wingkwong in #5498
• Moving backend to nestjs by @pranavxc in #5444
• New Crowdin updates by @o1lab in #5519
• chore(deps): bump vm2 from 3.9.16 to 3.9.17 in /packages/nocodb by @dependabot in #5515
• chore(deps): bump yaml and @commitlint/load in /packages/nc-plugin by @dependabot in #5535
• chore(deps): bump yaml from 2.1.3 to 2.2.2 in /tests/playwright by @dependabot in #5534
• chore(deps): bump vm2 from 3.9.16 to 3.9.17 in /packages/nocodb-nest by @dependabot in #5516
• fix(nc-gui): retrieve the comment part from the audit description by @wingkwong in #5513
• New Crowdin updates by @o1lab in #5538
• fix(nocodb): allow kanban for calling publicHmList and publicMmList by @wingkwong in #5536
• 🔦 Feature: Confirmation on delete record by @gitstart in #5419
• test: sync optimisation changes by @dstala in #5537
• New Crowdin updates by @o1lab in #5563
• feat: add description field to meta tables by @pranavxc in #5540
• add mysql to helm chart by @sgeist-ionos in #5162
• fix: create meta db if missing by @pranavxc in #5566
• fix(nc-gui): input focus in expanded form by @wingkwong in #5539
• Github action changes for deploying nestjs backend by @pranavxc in #5510
• feat: webhook body edit by @wingkwong in #5530
• fix: api-token strategy correction by @pranavxc in #5572
• fix(nocodb): allow gallery to access hm / bt / mm list by @wingkwong in #5570
• Refactor - rename package folder names in monorepo by @pranavxc in #5569
• 0.107.0-beta.0 Pre-release by @github-actions in #5587

Full Changelog: 0.106.1...0.107.0-beta.0

0.106.1: Bug Fix Release

🚀 NocoDB : Bug Fix Release

🐛 Closed Issues

• [🐛 Type: Bug] 🐛 Bug: LinkToAnotherRecord dosen't work in Shared View Forms #5488
• [🐛 Type: Bug] 🐛 Bug: Drag drop image broken in expanded record & form view #5486
• [Status: Reproducible] 🐛 Bug: Text selected alongside cells #5484
• [closed] 🐛 Bug: Formula error #5478
• [🐛 Type: Bug] 🐛 Bug: Table name expected to be unique across data sources #5477
• [closed] 🐛 Bug: can't find swagger.json anymore #5474
• [🐛 Type: Bug] 🐛 Bug: OR() formula broken as of 0.106.0 #5471
• [closed] 🐛 Bug: form-view mode Attachment failed to upload #5470
• [closed] Link in REST APIs documentation redirects to a 404 page #5468
• [🐛 Type: Bug][🐹 DB : SQLite] Error when using PATCH http://localhost:8080/api/v1/db/data/bulk/{orgs}/{projectName}/{tableName}: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call? #5467
• [closed] 🔦 Feature: We have questions about commercial licensing, can you contact us? #5464
• [🐛 Type: Bug][🐘 DB : Postgres] 🐛 Bug: Formula Statement SEARCH not working #5460
• [🐛 Type: Bug] 🐛 Bug: API User Signout 404 Not Found' for url 'xxxxxxxx/api/v1/auth/user/signout #5459
• [closed] 🐛 Bug: API Where clause not working with 106 #5456
• [closed] 🔦 Feature: Fill PDF form #5453
• [closed] 🐛 Bug: Link feature is not working #5451
• [🏗️ Type: In Development] 🐛 Bug: non-pk system column as display value #5450
• [🐛 Type: Bug] 🐛 Bug: incorrect results of concat formula #5449
• [🐛 Type: Bug] 🐛 Bug: Checkbox ColumnType cannot be updated MSSQL #5440
• [🐛 Type: Bug] 🐛 Bug: Uploading files via forms #5434
• [closed] 🐛 Bug: vultr s3 bucket #5401
• [closed] 🐛 Bug: various small annoyances #5377
• [🐛 Type: Bug] 🐛 Bug: VULNERABILITY: Sign Out doesn't work #5361
• [closed] 🐛 Bug: Slow Performance #5136
• [🔦 Type: Feature] 🔦 Feature: Send what changed in webhook data when update action is triggered #3869
• [🔦 Type: Feature][🚘 Scope : Automation] [Feature] CSV import Webhook trigger #1582

What's Changed

• Release 0.106.0 by @github-actions in #5447
• New Crowdin updates by @o1lab in #5448
• fix(nocodb): add missing parsing logic by @wingkwong in #5457
• feat(nc-gui): add check all on action column editor import modal by @khisby in #5455
• chore(deps): bump vm2 from 3.9.15 to 3.9.16 in /packages/nocodb by @dependabot in #5461
• fix(nc-gui): sign out issue by @wingkwong in #5458
• fix(nocodb): search formula in pg.ts by @wingkwong in #5466
• fix: formula concat by @wingkwong in #5463
• fix: vultr plugin by @wingkwong in #5445
• fix(nc-gui): form attachments by @wingkwong in #5454
• fix(nocodb): incorrect OR builder by @wingkwong in #5472
• docs: adopt NuxtLink for internal routes by @wingkwong in #5469
• test: formula verification for OR, AND, IF, SEARCH by @dstala in #5480
• New Crowdin updates by @o1lab in #5476
• fix(nc-gui): table alias across bases by @wingkwong in #5479
• fix(nocodb): bulk update transaction by @wingkwong in #5491
• fix(nc-gui): drag n drop attachment cell by @wingkwong in #5493
• fix(nocodb): LTAR list in shared form / grid by @wingkwong in #5490
• fix(nc-gui): select issue in grid view by @wingkwong in #5494
• fix(nc-gui): checkbox in mssql by @wingkwong in #5475
• test: docker PG version upgrade by @dstala in #5481
• enhancement: cache on list by @wingkwong in #5430
• 0.106.1 Pre-release by @github-actions in #5500

New Contributors

• @khisby made their first contribution in #5455

Full Changelog: 0.106.0...0.106.1

0.106.0

🚀 NocoDB Feature Release : Undo/Redo, Webhooks revamped & UX Performance improved 🚀

🥬 What's new .. What's fresh ?

Date / DateTime Filters

• Introduce is after, is before, is on or after and is on or before, isWithin for date and datetime.
• Introduce sub-operations: today, tomorrow, yesterday, oneWeekAgo, oneWeekFromNow, oneMonthAgo, oneMonthFromNow, daysAgo, daysFromNow, exactDate. For isWithin, we have the following sub-operations instead: pastWeek, pastMonth, pastYear, nextWeek, nextMonth, nextYear, nextNumberOfDays, pastNumberOfDays
• Existing is like and is not like filters will be removed.
• Existing is empty, is not empty, is null, is not null will be migrated to blank and not blank.

Undo

Scope	Actions
Row	Create, Update, Delete
LTAR	Link, Unlink
Fields	Show/hide, Reorder
Sort	Add, Update, Delete
Filters	Add, Update, Delete (Excluding Filter Groups)
Row Height	Update
Column width	Update
View	Rename
Table	Rename

Revamp

Webhook v2

• New Webhooks will be considered as v2. The existing webhooks (v1) will remain unchanged.
• Webhook response for update & delete triggers now carry record information before & after event
• Webhook triggers are now available for bulk events as well
• Webhook Call Log with option to enable/disable them using environment variables. (Also available in v1 webhooks)

Others

• UI Icons
• Adopted Controller and Service Pattern
• API Validations
• API Docs
• Performance Tuning

❗Breaking changes

Metadata API Responses

The following Listing API responses will be wrapped by list and pageInfo is available in some APIs currently.

{
  "list": [{...}, {...}],
  "pageInfo": {...}
}

• /api/v1/db/meta/projects/:projectId/api-tokens
• /api/v1/db/meta/audits/comments
• /api/v1/db/meta/views/:viewId/filters
• /api/v1/db/meta/filters/:filterParentId/children
• /api/v1/db/meta/hooks/:hookId/filters
• /api/v1/db/meta/views/:viewId/sorts/
• /api/v1/db/meta/tables/:tableId/views
• /api/v1/db/meta/tables/:tableId/share
• /api/v1/db/meta/views/:viewId/columns/
• /api/v1/users

Hook Sample Payload API Change

From

/api/v1/db/meta/tables/:tableId/hooks/samplePayload/:operation/

to

/api/v1/db/meta/tables/:tableId/hooks/samplePayload/:operation/:version

Coming soon!

GeoData + Map View ( Sneak peak )

The new feature launch includes beta access for GeoData column and Map View. With this, users can easily input and view location data associated with their records, making it easier to analyse and interpret data based on geography. The Map View feature allows users to visualise their data on an interactive map. Users can filter their data by location, zoom in and out. Overall, the GeoData column and Map View feature provides powerful tool that adds a new dimension to data analysis, providing users with an intuitive and visually engaging way to explore and interpret their data.

Mobile mode (Sneak peak )

A toggle button is now available in beta access, which enabled will

• helps simplify UI layout for mobile view.
• enable's QR scan option to retrieve a stored record.

Note that, Sneak peak features are work in progress & needs to be explicitly enabled using easter egg menu. Please get in touch with us for more details.

Join Our Team

Thank you for your love & support

💜 🚀

---

🐛 Closed Issues

• [closed] 🐛 Bug: Formula linked column references #5420
• [closed] 🐛 Bug: NocoDB is not syncing to Postgres #5418
• [closed] 🐛 Bug: Adding postgres data-source without CREATE ON DATABASE permission #5398
• [closed] Group rows like in Airtable #5387
• [closed] 🐛 Bug: minor UI corrections #5381
• [closed] 🐛 Bug: [dev] rollup icon not displayed #5380
• [closed] let's go oracle #5376
• [closed] drag and drop a table in another database [Feature] #5362
• [closed] 🐛 Bug: VULNERABILITY: Sign Out doesn't work #5361
• [closed] 🔦 Feature: Add icon reset option #5356
• [closed] 🐛 Bug: Failure to download doc attachment #5344
• [🔎 Status: More Info Needed] 🐛 Bug: BullMQ: DEPRECATION WARNING! Your redis options maxRetriesPerRequest must be null. On the next versions having this settings will throw an exception #5335
• [closed] 🐛 Bug: Unable to download attachment #5326
• [closed] 🐛 Bug: run Noco-win-x64.exe got error: 'Z_DATA_ERROR' #5318
• [🐛 Type: Bug] 🐛 Bug: Cannot use backslash \ in formula #5315
• [closed] 🐛 Bug: filtering a view on a date field causes 500 error #5308
• [🐛 Type: Bug] 🐛 Bug: row number not syncing between pages #5304
• [🐛 Type: Bug] 🐛 Bug: non-image attachments cannot be opened after upload #5302
• [closed] UI enhancements #5260
• [🐬 DB : MySQL] 🐛 Bug: Mysql Decimal Field length 10 is not enough #5259
• [closed] undo #5258
• [🐛 Type: Bug][🐘 DB : Postgres] 🐛 Bug:Use of ? in column name throws error #5255
• [closed] 🐛 Bug: Advanced column options are not displayed #5245
• [closed] 🐛 Bug: Filter on rollup error's out in PG #5232
• [🐛 Type: Bug] 🐛 Bug: Error thrown when editing a form #5231
• [closed] 🐛 Bug: Swagger schema not matching API call result #5224
• [closed] 🐛 Bug: Using a ‘?’ does not work with concat #5220
• [closed] 🐛 Bug: project setting "Show NULL and EMPTY in Filter" has no effect #5219
• [🐛 Type: Bug] 🐛 Bug: "is blank" filter not yielding any results on LinkToAnotherRecord column #5218
• [closed] 🐛 Bug: Docker build missing dependency #5216
• [Status: Reproducible] 🐛 Bug: Replace in formula issues #5209
• [closed] 🐛 Bug: In external form view, column definitions can be altered #5205
• [closed] Map View Follow-up items #5203
• [closed] Column type autonumber #5201
• [closed] 🔦 Feature: Activity.Copyview, copy the costom width of the column #5198
• [closed] 🐛 Bug: Activity.ListSharedView double click Table headers #5197
• [closed] Custom user role #5192
• [closed] 🐛 Bug: Cannot change Single and MultiSelect value from the Child list #5191
• [🔎 Status: More Info Needed] 🐛 Bug: Content of columns with LongText is not visible with Microsoft Edge Dev #5190
• [closed] Date Filter doesn't include date operations #5186
• [Status: Reproducible] 🐛 Bug: SpecificDBType select is missing #5182
• [🔎 Status: More Info Needed] 🐛 Bug: UI not updating in Development Setup #5180
• [🐛 Type: Bug] 🐛 Bug: SingleSelect focus is a bit broken in Firefox #5179
• [closed] [Feature] pag...

0.106.0-beta.1

🚀 NocoDB Feature Release : Undo/Redo, Webhooks revamped & UX Performance improved 🚀

🥬 What's new .. What's fresh ?

Date / DateTime Filters

• Introduce is after, is before, is on or after and is on or before, isWithin for date and datetime.
• Introduce sub-operations: today, tomorrow, yesterday, oneWeekAgo, oneWeekFromNow, oneMonthAgo, oneMonthFromNow, daysAgo, daysFromNow, exactDate. For isWithin, we have the following sub-operations instead: pastWeek, pastMonth, pastYear, nextWeek, nextMonth, nextYear, nextNumberOfDays, pastNumberOfDays
• Existing is like and is not like filters will be removed.
• Existing is empty, is not empty, is null, is not null will be migrated to blank and not blank.

Undo

Scope	Actions
Row	Create, Update, Delete
LTAR	Link, Unlink
Fields	Show/hide, Reorder
Sort	Add, Update, Delete
Filters	Add, Update, Delete (Excluding Filter Groups)
Row Height	Update
Column width	Update
View	Rename
Table	Rename

Revamp

Webhook v2

• New Webhooks will be considered as v2. The existing webhooks (v1) will remain unchanged.
• Webhook response for update & delete triggers now carry record information before & after event
• Webhook triggers are now available for bulk events as well
• Webhook Call Log with option to enable/disable them using environment variables. (Also available in v1 webhooks)

Others

• UI Icons
• Adopted Controller and Service Pattern
• API Validations
• API Docs
• Performance Tuning

❗Breaking changes

Metadata API Responses

The following Listing API responses will be wrapped by list and pageInfo is available in some APIs currently.

{
  "list": [{...}, {...}],
  "pageInfo": {...}
}

• /api/v1/db/meta/projects/:projectId/api-tokens
• /api/v1/db/meta/audits/comments
• /api/v1/db/meta/views/:viewId/filters
• /api/v1/db/meta/filters/:filterParentId/children
• /api/v1/db/meta/hooks/:hookId/filters
• /api/v1/db/meta/views/:viewId/sorts/
• /api/v1/db/meta/tables/:tableId/views
• /api/v1/db/meta/tables/:tableId/share
• /api/v1/db/meta/views/:viewId/columns/
• /api/v1/users

Hook Sample Payload API Change

From

/api/v1/db/meta/tables/:tableId/hooks/samplePayload/:operation/

to

/api/v1/db/meta/tables/:tableId/hooks/samplePayload/:operation/:version

Coming soon!

GeoData + Map View ( Sneak peak )

The new feature launch includes beta access for GeoData column and Map View. With this, users can easily input and view location data associated with their records, making it easier to analyse and interpret data based on geography. The Map View feature allows users to visualise their data on an interactive map. Users can filter their data by location, zoom in and out. Overall, the GeoData column and Map View feature provides powerful tool that adds a new dimension to data analysis, providing users with an intuitive and visually engaging way to explore and interpret their data.

Mobile mode (Sneak peak )

A toggle button is now available in beta access, which enabled will

• helps simplify UI layout for mobile view.
• enable's QR scan option to retrieve a stored record.

Note that, Sneak peak features are work in progress & needs to be explicitly enabled using easter egg menu. Please get in touch with us for more details.

Join Our Team

Thank you for your love & support

💜 🚀

---

🐛 Closed Issues

• [closed] 🐛 Bug: Formula linked column references #5420
• [closed] 🐛 Bug: NocoDB is not syncing to Postgres #5418
• [closed] 🐛 Bug: Adding postgres data-source without CREATE ON DATABASE permission #5398
• [closed] Group rows like in Airtable #5387

What's Changed

• Release 0.106.0-beta.0 by @github-actions in #5395
• New Crowdin updates by @o1lab in #5400
• refactor: webhooks by @wingkwong in #5349
• Update link for portuguese language by @poolborges in #5404
• fix (dbConfig): ssl connection with file path is not handled correctly by @kamalmahmudi in #5364
• refactor: Formula query builder optimization by @pranavxc in #5392
• New Crowdin updates by @o1lab in #5408
• fix(nocodb): Add postgres data source w/o CREATE ON DATABASE permission by @data-envoy in #5399
• fix: Maintain multi select option order by @pranavxc in #5413
• feat: local docker by @wingkwong in #5402
• New Crowdin updates by @o1lab in #5422
• New Crowdin updates by @o1lab in #5425
• fix: formula LTAR column references by @mertmit in #5421
• fix(nc-gui): page-size in pagination by @wingkwong in #5426
• 0.106.0-beta.1 Pre-release by @github-actions in #5427

New Contributors

• @poolborges made their first contribution in #5404
• @kamalmahmudi made their first contribution in #5364
• @data-envoy made their first contribution in #5399

Full Changelog: 0.106.0-beta.0...0.106.0-beta.1

0.106.0-beta.0

🚀 NocoDB Feature Release 🚀

🥬 What's new .. What's fresh ?

Date / DateTime Filters

• Introduce is after, is before, is on or after and is on or before, isWithin for date and datetime.
• Introduce sub-operations: today, tomorrow, yesterday, oneWeekAgo, oneWeekFromNow, oneMonthAgo, oneMonthFromNow, daysAgo, daysFromNow, exactDate. For isWithin, we have the following sub-operations instead: pastWeek, pastMonth, pastYear, nextWeek, nextMonth, nextYear, nextNumberOfDays, pastNumberOfDays
• Existing is like and is not like filters will be removed.
• Existing is empty, is not empty, is null, is not null will be migrated to blank and not blank.

Undo

Scope	Actions
Row	Create, Update, Delete
LTAR	Link, Unlink
Fields	Show/hide, Reorder
Sort	Add, Update, Delete
Filters	Add, Update, Delete (Excluding Filter Groups)
Row Height	Update
Column width	Update
View	Rename
Table	Rename

Revamp

• UI Icons
• Adopted Controller and Service pattern
• API Validations
• API Docs

❗Breaking changes

Metadata API Responses

The following Listing API responses will be formatted as

{
  "list": [{...}, {...}],
  "pageInfo": {...}
}

• /api/v1/db/meta/projects/:projectId/api-tokens
• /api/v1/db/meta/audits/comments
• /api/v1/db/meta/views/:viewId/filters
• /api/v1/db/meta/filters/:filterParentId/children
• /api/v1/db/meta/hooks/:hookId/filters
• /api/v1/db/meta/views/:viewId/sorts/
• /api/v1/db/meta/tables/:tableId/views
• /api/v1/db/meta/tables/:tableId/share
• /api/v1/db/meta/views/:viewId/columns/
• /api/v1/users

Join Our Team

Thank you for your love & support

💜 🚀

---

🐛 Closed Issues

• [closed] 🐛 Bug: minor UI corrections #5381
• [closed] 🐛 Bug: [dev] rollup icon not displayed #5380
• [closed] let's go oracle #5376
• [closed] drag and drop a table in another database [Feature] #5362
• [closed] 🐛 Bug: VULNERABILITY: Sign Out doesn't work #5361
• [closed] 🔦 Feature: Add icon reset option #5356
• [closed] 🐛 Bug: Failure to download doc attachment #5344
• [🔎 Status: More Info Needed] 🐛 Bug: BullMQ: DEPRECATION WARNING! Your redis options maxRetriesPerRequest must be null. On the next versions having this settings will throw an exception #5335
• [closed] 🐛 Bug: Unable to download attachment #5326
• [closed] 🐛 Bug: run Noco-win-x64.exe got error: 'Z_DATA_ERROR' #5318
• [🐛 Type: Bug] 🐛 Bug: Cannot use backslash \ in formula #5315
• [closed] 🐛 Bug: filtering a view on a date field causes 500 error #5308
• [🐛 Type: Bug] 🐛 Bug: row number not syncing between pages #5304
• [🐛 Type: Bug] 🐛 Bug: non-image attachments cannot be opened after upload #5302
• [closed] UI enhancements #5260
• [🐬 DB : MySQL] 🐛 Bug: Mysql Decimal Field length 10 is not enough #5259
• [closed] undo #5258
• [🐛 Type: Bug][🐘 DB : Postgres] 🐛 Bug:Use of ? in column name throws error #5255
• [closed] 🐛 Bug: Advanced column options are not displayed #5245
• [closed] 🐛 Bug: Filter on rollup error's out in PG #5232
• [🐛 Type: Bug] 🐛 Bug: Error thrown when editing a form #5231
• [closed] 🐛 Bug: Swagger schema not matching API call result #5224
• [closed] 🐛 Bug: Using a ‘?’ does not work with concat #5220
• [closed] 🐛 Bug: project setting "Show NULL and EMPTY in Filter" has no effect #5219
• [🐛 Type: Bug] 🐛 Bug: "is blank" filter not yielding any results on LinkToAnotherRecord column #5218
• [closed] 🐛 Bug: Docker build missing dependency #5216
• [Status: Reproducible] 🐛 Bug: Replace in formula issues #5209
• [closed] 🐛 Bug: In external form view, column definitions can be altered #5205
• [closed] Map View Follow-up items #5203
• [closed] Column type autonumber #5201
• [closed] 🔦 Feature: Activity.Copyview, copy the costom width of the column #5198
• [closed] 🐛 Bug: Activity.ListSharedView double click Table headers #5197
• [closed] Custom user role #5192
• [closed] 🐛 Bug: Cannot change Single and MultiSelect value from the Child list #5191
• [🔎 Status: More Info Needed] 🐛 Bug: Content of columns with LongText is not visible with Microsoft Edge Dev #5190
• [closed] Date Filter doesn't include date operations #5186
• [Status: Reproducible] 🐛 Bug: SpecificDBType select is missing #5182
• [🔎 Status: More Info Needed] 🐛 Bug: UI not updating in Development Setup #5180
• [🐛 Type: Bug] 🐛 Bug: SingleSelect focus is a bit broken in Firefox #5179
• [closed] [Feature] page transition #5177
• [Status: Reproducible] 🐛 Bug: Cell exits edit mode when clicking inside the same cell #5170
• [closed] 🐛 Bug: clicking save button multiple times on "new column" or "edit column" will fire multiple queries #5158
• [✨ Type: Enhancement] 🔦 Enhancement: add shortcut to navigate to next & previous records in Expanded row #5124
• [closed] 🐛 Bug: Frozen grid view details even after closing all tabs #5121
• [closed] 🔦 Feature: Prefilled forms #5107
• [closed] 🐛 Bug: Wrong baseId is used in QuickImport, when a secondary database is only active. So the Table is created in the hidden DB. #5103
• [closed] 🐛 Bug: Losing Super Admin role after upgrading from 0.101.2 to 0.104.3 #5101
• [closed] 🐛 Bug: No autosave when moving to "Next Row" in expanded record view #5049
• [closed] Feature: In shared Grid view it's not possible to edit or add data #5028
• [closed] 🔦 Feature: Add rows using .xlsx #5021
• [🔦 Type: Feature] 🔦 Feature: Abiliy to select date field through date picker in filter #4655
• [✨ Type: Enhancement] Enhancement: Provide access to common data like project ID in Webhook JSON response #4594
• [🔦 Type: Feature] 🔦 Feature: The Editor need the function of ”Upload EXCEL“,import .xlsx file #4271
• [🔦 Type: Feature] [Feature] Add users field to tables #3787
• [🔦 Type: Feature] [Feature] Webhooks only for specific columns #3693
• [🔦 Type: Feature] [Feature] Expanded record view : provide option to display hidden fields #3513
• [🔦 Type: Feature][🌮 Scope : Table] [Feature] Empty table contents #2997
• [🔦 Type: Feature][🚘 Scope : Automation] [Feature] Access old field values in webhooks #2902
• [🔭 Scope : Project] [Feature] unique columns #2778
• [✨ Type: Enhancement][🔦 Type: Feature][🍰 Scope : Column] Allow editing of a Lookup column #2574
• [✨ Type: Enhancement][🔦 Type: Feature][🍰 Scope : Column] Link Multiple Records to Another Record at the same time (multi-select record linking) #2564
• [👋 For : Community or Good First Issue] Inflection: none is still capitali...

0.105.3: Bug Fix Release

🚀 NocoDB : Bug Fix Release

🐛 Closed Issues

• [closed] 🔦 Feature: using LinkToAnotherRecord for linking a row to a user from the teams & management #5169
• [closed] Migration failed : 0100002 to 0104004 #5147
• [closed] 🐛 Bug: sticky column field can be dragged & realigned in sql views #5122
• [🔦 Type: Feature] 🔦 Feature: Make stable bound to the audit log #4643
• [🔦 Type: Feature] 🔦 Feature: LinkToAnotherRecord with a filter set of records #4541
• [closed] 🔦 Feature: parent_id primary key #4319
• [🐛 Type: Bug] 🐛 Bug: Filter's visibility for different users #4228
• [🔎 Status: More Info Needed] 🐛 Bug: Import - Single Select automatic parsing error #4217
• [🔦 Type: Feature] 🔦 Feature: project lists order manually #4132
• [🔦 Type: Feature] Sticky column to the side #4110
• [closed] 🐛 Bug: Import excel / airtable easily accessible #4013
• [🔦 Type: Feature] 🔦 Feature: Option to delete all rows when there are multiple pages #3870

What's Changed

• Release 0.105.2 by @github-actions in #5145
• [docs]: Update docs: app store directory correction, add social links. by @kyleecodes in #5149
• feat: implement NC_DISABLE_AUDIT by @wingkwong in #5137
• feat(nocodb): set cache header for attachment urls by @pranavxc in #5151
• New Crowdin updates by @o1lab in #5123
• feat: upgrade timeout msg by @wingkwong in #5154
• fix: ts types for sql clients by @mertmit in #5134
• fix(nc-gui): add missing filterChildrenRead permission by @wingkwong in #5167
• feat(gui): Support multiple record mapping without closing LTAR modal by @pranavxc in #5153
• refactor: use extractProps by @wingkwong in #5168
• fix: missing display value by @mertmit in #5141
• 0.105.3 Pre-release by @github-actions in #5175

Full Changelog: 0.105.2...0.105.3

0.105.2: Bug Fix Release

🚀 NocoDB : Bug Fix Release

🐛 Closed Issues

• [closed] 🐛 Bug: Accessing root url showing old dummy page #5142

What's Changed

• Release 0.105.1 by @github-actions in #5140
• test: swagger by @dstala in #5139
• fix: remove dummy page by @pranavxc in #5143
• 0.105.2 Pre-release by @github-actions in #5144

Full Changelog: 0.105.1...0.105.2