8000 fix: filters / conditions by wingkwong · Pull Request #2535 · nocodb/nocodb · GitHub
[go: up one dir, main page]
More Web Proxy on the site http://driver.im/
Skip to content

fix: filters / conditions #2535

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 9 commits into from
Jul 5, 2022
Merged

fix: filters / conditions #2535

merged 9 commits into from
Jul 5, 2022

Conversation

wingkwong
Copy link
Contributor
@wingkwong wingkwong commented Jul 2, 2022

Change Summary

ref: #2516

  • check if input is string in sanitize / unsanitize
  • revise ColumnFilter logic
    • bt: is null & is not null
    • hm / mm: is empty & is not empty
    • lookup: disable is null, is not null, is empty & is not empty
  • revise bt & hm condition logic
  • revise operation & filter value display logic

Change type

  • feat: (new feature for the user, not a new feature for build script)
  • fix: (bug fix for the user, not a fix to a build script)
  • docs: (changes to the documentation)
  • style: (formatting, missing semi colons, etc; no production code change)
  • refactor: (refactoring production code, eg. renaming a variable)
  • test: (adding missing tests, refactoring tests; no production code change)
  • chore: (updating grunt tasks etc; no production code change)

Test/ Verification

Sheet 1: hm
image

image

image

Sheet 2: bt

image

image

image

Sheet 3 : mm

image

image

image

Sheet 4: mm

image

image

image

Display Flow

  1. Choose the field first

image

  1. Render corresponding operations

image

  1. Render filter value if applicable

image

@wingkwong wingkwong marked this pull request as ready for review July 2, 2022 06:38
@wingkwong wingkwong requested a review from pranavxc July 2, 2022 06:38
@wingkwong wingkwong added this to the Next Release : v0.92.x milestone Jul 2, 2022
@wingkwong wingkwong requested a review from mertmit July 5, 2022 07:35
@wingkwong wingkwong assigned mertmit and unassigned pranavxc Jul 5, 2022
@wingkwong wingkwong removed the request for review from pranavxc July 5, 2022 07:35
Copy link
Member
@mertmit mertmit left a comment

Choose a reason for hiding this comment

The reason will be displayed to describe this comment to others. Learn more.

Filter Type Many to many Has many Belongs to Lookup
is null ✔️
is not null ✔️
is empty ✔️ ✔️
is not empty ✔️ ✔️

✔️ -> tested & working
✅ -> restricted from UI

The only thing is if someone has 'is not null filter' on mm or hm columns which seem to work, it becomes an empty filter which still applied but user can delete or change it so this should be fine

temp

@wingkwong wingkwong merged commit 80a350a into develop Jul 5, 2022
@wingkwong wingkwong deleted the fix/filter branch July 6, 2022 09:57
o1lab pushed a commit that referenced this pull request Mar 14, 2024
o1lab pushed a commit that referenced this pull request Mar 15, 2024
dstala added a commit that referenced this pull request Mar 15, 2024
* fix(nc-gui): select type fields default value update issue

* chore(nc-gui): lint

* fix(nc-gui): pr review changes #2535

* fix: remove null assertion

---------

Co-authored-by: Raju Udava <86527202+dstala@users.noreply.github.com>
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging this pull request may close these issues.

3 participants
0