refine
refine copied to clipboard
feat(supabase): filter array column by array (`ina` and `nina` operators)
PR Checklist
Please check if your PR fulfills the following requirements:
- [x] The commit message follows our guidelines: https://refine.dev/docs/guides-concepts/contributing/#commit-convention
Bugs / Features
- [x] Related issue(s) linked
- [x] Tests for the changes have been added
- [x] Docs have been added / updated
- [x] Changesets have been added https://refine.dev/docs/guides-concepts/contributing/#creating-a-changeset
What is the current behavior?
No ina and nina
What is the new behavior?
Now it is possible to filter using ina and nina CRUD operators in supabase data provider. It allows for filtering array columns by matching all values inside array.
fixes #5902
Notes for reviewers
🦋 Changeset detected
Latest commit: 84bf034c7f6df12cfd0837160125cac9f340a19d
The changes in this PR will be included in the next version bump.
This PR includes changesets to release 2 packages
| Name | Type |
|---|---|
| @refinedev/core | Minor |
| @refinedev/supabase | Minor |
Not sure what this means? Click here to learn what changesets are.
Click here if you're a maintainer who wants to add another changeset to this PR
☁️ Nx Cloud Report
CI is running/has finished running commands for commit bdd99ee2dbe0de1287918aec50b934a694495578. As they complete they will appear below. Click to see the status, the terminal output, and the build insights.
📂 See all runs for this CI Pipeline Execution
✅ Successfully ran 60 targets
lerna run cypress:run --scope with-remix-material-ui -- --record --key --group with-remix-material-uilerna run cypress:run --scope with-remix-headless -- --record --key --group with-remix-headlesslerna run cypress:run --scope with-remix-antd -- --record --key --group with-remix-antdlerna run cypress:run --scope with-nextjs-next-auth -- --record --key --group with-nextjs-next-authlerna run cypress:run --scope with-nextjs -- --record --key --group with-nextjslerna run cypress:run --scope form-material-ui-use-steps-form -- --record --key --group form-material-ui-use-steps-formlerna run cypress:run --scope auth-mantine -- --record --key --group auth-mantinelerna run cypress:run --scope form-material-ui-use-modal-form -- --record --key --group form-material-ui-use-modal-formlerna run cypress:run --scope auth-keycloak -- --record --key --group auth-keycloaklerna run cypress:run --scope data-provider-supabase -- --record --key --group data-provider-supabaselerna run cypress:run --scope table-react-table-basic -- --record --key --group table-react-table-basiclerna run cypress:run --scope table-react-table-advanced -- --record --key --group table-react-table-advancedlerna run cypress:run --scope form-material-ui-use-form -- --record --key --group form-material-ui-use-formlerna run cypress:run --scope table-material-ui-use-update-many -- --record --key --group table-material-ui-use-update-manylerna run cypress:run --scope auth-headless -- --record --key --group auth-headlesslerna run cypress:run --scope auth-google-login -- --record --key --group auth-google-loginlerna run cypress:run --scope data-provider-strapi-v4 -- --record --key --group data-provider-strapi-v4lerna run cypress:run --scope form-material-ui-use-drawer-form -- --record --key --group form-material-ui-use-drawer-formlerna run cypress:run --scope table-material-ui-use-delete-many -- --record --key --group table-material-ui-use-delete-manylerna run cypress:run --scope auth-chakra-ui -- --record --key --group auth-chakra-uilerna run cypress:run --scope table-material-ui-use-data-grid -- --record --key --group table-material-ui-use-data-gridlerna run cypress:run --scope form-material-ui-mutation-mode -- --record --key --group form-material-ui-mutation-modelerna run cypress:run --scope auth-auth0 -- --record --key --group auth-auth0lerna run cypress:run --scope table-material-ui-table-filter -- --record --key --group table-material-ui-table-filterlerna run cypress:run --scope table-material-ui-data-grid-pro -- --record --key --group table-material-ui-data-grid-prolerna run cypress:run --scope auth-antd -- --record --key --group auth-antdlerna run cypress:run --scope server-side-form-validation-material-ui -- --record --key --group server-side-form-validation-material-uilerna run cypress:run --scope table-material-ui-cursor-pagination -- --record --key --group table-material-ui-cursor-paginationlerna run cypress:run --scope form-mantine-use-steps-form -- --record --key --group form-mantine-use-steps-formlerna run cypress:run --scope server-side-form-validation-mantine -- --record --key --group server-side-form-validation-mantinelerna run cypress:run --scope table-material-ui-advanced -- --record --key --group table-material-ui-advancedlerna run cypress:run --scope base-material-ui -- --record --key --group base-material-uilerna run cypress:run --scope server-side-form-validation-chakra-ui -- --record --key --group server-side-form-validation-chakra-uilerna run cypress:run --scope form-mantine-use-modal-form -- --record --key --group form-mantine-use-modal-formlerna run cypress:run --scope table-mantine-basic -- --record --key --group table-mantine-basiclerna run cypress:run --scope server-side-form-validation-antd -- --record --key --group server-side-form-validation-antdlerna run cypress:run --scope base-mantine -- --record --key --group base-mantinelerna run cypress:run --scope inferencer-material-ui -- --record --key --group inferencer-material-uilerna run cypress:run --scope table-mantine-advanced -- --record --key --group table-mantine-advancedlerna run cypress:run --scope form-chakra-ui-mutation-mode -- --record --key --group form-chakra-ui-mutation-modelerna run cypress:run --scope table-handson -- --record --key --group table-handsonlerna run cypress:run --scope table-chakra-ui-basic -- --record --key --group table-chakra-ui-basiclerna run cypress:run --scope base-chakra-ui -- --record --key --group base-chakra-uilerna run cypress:run --scope form-antd-use-steps-form -- --record --key --group form-antd-use-steps-formlerna run cypress:run --scope inferencer-mantine -- --record --key --group inferencer-mantinelerna run cypress:run --scope table-chakra-ui-advanced -- --record --key --group table-chakra-ui-advancedlerna run cypress:run --scope base-antd -- --record --key --group base-antdlerna run cypress:run --scope form-antd-use-modal-form -- --record --key --group form-antd-use-modal-formlerna run cypress:run --scope table-antd-use-update-many -- --record --key --group table-antd-use-update-manylerna run cypress:run --scope auth-material-ui -- --record --key --group auth-material-uilerna run cypress:run --scope form-antd-use-form -- --record --key --group form-antd-use-formlerna run cypress:run --scope table-antd-use-table -- --record --key --group table-antd-use-tablelerna run cypress:run --scope table-antd-use-editable-table -- --record --key --group table-antd-use-editable-tablelerna run cypress:run --scope form-antd-use-drawer-form -- --record --key --group form-antd-use-drawer-formlerna run cypress:run --scope inferencer-headless -- --record --key --group inferencer-headlesslerna run cypress:run --scope table-antd-use-delete-many -- --record --key --group table-antd-use-delete-manylerna run cypress:run --scope form-antd-mutation-mode -- --record --key --group form-antd-mutation-modelerna run cypress:run --scope table-antd-table-filter -- --record --key --group table-antd-table-filterlerna run cypress:run --scope table-antd-advanced -- --record --key --group table-antd-advancedlerna run cypress:run --scope form-antd-custom-validation -- --record --key --group form-antd-custom-validation
Sent with 💌 from NxCloud.
Deploy Preview for refine-video-club ready!
| Name | Link |
|---|---|
| Latest commit | 095e45f53c5b24f116a8a688cc1af48c8c3d75e4 |
| Latest deploy log | https://app.netlify.com/sites/refine-video-club/deploys/663c6d300e5394000829c11a |
| Deploy Preview | https://deploy-preview-5922--refine-video-club.netlify.app |
| Preview on mobile | Toggle QR Code...Use your smartphone camera to open QR code link. |
To edit notification comments on pull requests, go to your Netlify site configuration.
Hello, @issa012. Thanks for the PR 🚀
As you can see, the CI is failing but this is not related to the changes you made. First, I will solve this problem in another PR and then we will review your PR.
Failing CI will be resolved after #5937 is merged.
@issa012 Hello again, will you be able to find time to continue with the PR?
@alicanerdurmaz Hello. Yes I will complete it today
After pnpm install every package was installed and built, is this normal behavior now?
Also, there are other filters in supabase, that seem to be missing. If you open an issue with descriptions, I could implement them too.
Also, there are other filters in
supabase, that seem to be missing. If you open an issue with descriptions, I could implement them too.
Thanks, I will look into that! But, If you want, you can open an issue too.
After
pnpm installevery package was installed and built, is this normal behavior now?
Hey @issa012, this is the expected default behavior with our pnpm monorepo setup. Check out our Contributing Guide you can ignore these builds by passing --ignore-scripts 🚀