NocoDB 0.92.4 — Release Notes & Engineering Impact

# 🚀 [NocoDB](https://nocodb.com) Feature release - Filter Groups <img width="1054" alt="NOCODB : Grouped Filters" src="https://user-images.githubusercontent.com/5435402/179346702-9098b4c5-c95a-4e68-9adb-c9084ecbeaf8.png"> ## 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](http://careers.nocodb.com)! :fire: ## Filter Groups Filter conditions are now available to be grouped to achieve more advanced filtering. <img width="1068" alt="filter (1)" src="https://user-images.githubusercontent.com/5435402/179346137-9a86e3b9-3733-44cb-9469-224bd15b9ce5.png"> ## 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 * refactor: i18n/korean language translation corrections by @seokjunjin in https://github.com/nocodb/nocodb/commit/582bcf2dbef78438e62b82620bb9cfc52c331faa * 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 * @seokjunjin made their first contribution in https://github.com/nocodb/nocodb/commit/582bcf2dbef78438e62b82620bb9cfc52c331faa **Full Changelog**: https://github.com/nocodb/nocodb/compare/0.92.3...0.92.4 # Join Our Team <p align=""><a href="http://careers.nocodb.com" target="_blank"><img src="https://user-images.githubusercontent.com/61551451/169663818-45643495-e95b-48e2-be13-01d6a77dc2fd.png" width="250"/></a></p>