🚀 NocoDB Feature release - Filter Groups

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.

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:

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

• test/cypress: grid virtual cell validation by @dstala in https://github.com/nocodb/nocodb/pull/2526
• 0.92.3 Pre-release by @github-actions in https://github.com/nocodb/nocodb/pull/2529
• Release 0.92.3 by @github-actions in https://github.com/nocodb/nocodb/pull/2530
• Update spanish.md by @cande1gut in https://github.com/nocodb/nocodb/pull/2542
• docs: add cande1gut as a contributor for code by @allcontributors in https://github.com/nocodb/nocodb/pull/2543
• enhancement: edit project by @wingkwong in https://github.com/nocodb/nocodb/pull/2540
• fix: permission to remove link by @mertmit in https://github.com/nocodb/nocodb/pull/2541
• feat: migrate sqlclient by @pranavxc in https://github.com/nocodb/nocodb/pull/2537
• fix: Removed auto snake casing for table name on creation by @mustafapc19 in https://github.com/nocodb/nocodb/pull/2549
• fix: add missing settings permissions by @wingkwong in https://github.com/nocodb/nocodb/pull/2548
• fix: filters / conditions by @wingkwong in https://github.com/nocodb/nocodb/pull/2535
• fix: pg cast type for like condition by @mertmit in https://github.com/nocodb/nocodb/pull/2531
• Add date format option to DatePickerCell by @elvus in https://github.com/nocodb/nocodb/pull/2534
• fix: drop token_version check for password reset by @mertmit in https://github.com/nocodb/nocodb/pull/2568
• chore(deps): bump parse-url from 6.0.0 to 6.0.2 in /packages/noco-docs by @dependabot in https://github.com/nocodb/nocodb/pull/2577
• chore(deps): bump parse-url from 6.0.0 to 6.0.2 in /packages/noco-docs-prev by @dependabot in https://github.com/nocodb/nocodb/pull/2578
• enhancement: delete table on tree view by @wingkwong in https://github.com/nocodb/nocodb/pull/2547
• fix: Fixed Lookup cell image handling by @mustafapc19 in https://github.com/nocodb/nocodb/pull/2559
• Fix/2550 Removed Lookup, Rollup and Formula columns showing up in form by @mustafapc19 in https://github.com/nocodb/nocodb/pull/2588
• Fixed dark mode styling bug with edit column and styling issues with toggle comments button by @mustafapc19 in https://github.com/nocodb/nocodb/pull/2582
• fix: skip meta migration if associated project doesn't exist by @pranavxc in https://github.com/nocodb/nocodb/pull/2560
• fix/Fixed empty pills from appearing in lookup column, unwanted tables appearing in lookup dropdown and UI issue of sort by @mustafapc19 in https://github.com/nocodb/nocodb/pull/2611
• fix: delete rows containing m2m / hm data by @wingkwong in https://github.com/nocodb/nocodb/pull/2608
• feat: shuffle option in list api by @wingkwong in https://github.com/nocodb/nocodb/pull/2558
• fix: query param aliases for various API endpoints by @mertmit in https://github.com/nocodb/nocodb/pull/2637
• fix: use nullish coalescing instead of OR on PagedResponseImpl by @mertmit in https://github.com/nocodb/nocodb/pull/2648
• fix: large characters in table create by @wingkwong in https://github.com/nocodb/nocodb/pull/2646
• enhancement: formula display by @wingkwong in https://github.com/nocodb/nocodb/pull/2652
• Fix/invalid reset url bug by @pranavxc in https://github.com/nocodb/nocodb/pull/2672
• feat: enable grouped filter and some css corrections by @pranavxc in https://github.com/nocodb/nocodb/pull/2670
• enhancement: allow disabling download csv on a shared view by @wingkwong in https://github.com/nocodb/nocodb/pull/2552
• fix: import cn & tn replace regex by @wingkwong in https://github.com/nocodb/nocodb/pull/2682
• Fix - Grouped filter unexpected behaviour by @pranavxc in https://github.com/nocodb/nocodb/pull/2680
• feat/add-dynamic-feedback-form-submission by @mustafapc19 in https://github.com/nocodb/nocodb/pull/2641
• enhancement: sort menu by @wingkwong in https://github.com/nocodb/nocodb/pull/2687
• refactor: version api by @mertmit in https://github.com/nocodb/nocodb/pull/2686
• fix: handle nested group save in filter manual sync by @pranavxc in https://github.com/nocodb/nocodb/pull/2692
• 0.92.4 Pre-release by @github-actions in https://github.com/nocodb/nocodb/pull/2693

New Contributors

• @cande1gut made their first contribution in https://github.com/nocodb/nocodb/pull/2542
• @mustafapc19 made their first contribution in https://github.com/nocodb/nocodb/pull/2549
• @elvus made their first contribution in https://github.com/nocodb/nocodb/pull/2534

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

Join Our Team