[FEAT] Array filters support

[yf-hk]

Is your feature request related to a problem? Please describe.

Currently, Refine's data hooks (useList, useTable) don't support filtering array fields in databases that have native array support like PostgreSQL. When working with array columns (e.g., an 'ids' field containing an array of strings), there's no built-in way to filter records where the array contains a specific value.

Describe alternatives you've considered

Is there any workaround?

Additional context

No response

Describe the thing to improve

Support contains/includes operators for array fields
Work with PostgreSQL array columns natively
Provide a consistent API across different data providers
Allow combining array filters with other filter types
Support both string and number array types

[BatuhanW]

Hello @dzcpy we have ina and nina filter options in our CrudOperator type. That means in array and not in array. Would they be useful for your data provider?

[yf-hk]

Hi @BatuhanW, thanks for your reply! I have forked the crud module in my own project to fix some issues so that might be the reason. I'll check and probably close the ticket if it works!

[yf-hk]

Looks like ina and nina are not available for nestjsx crud adapter?
https://github.com/refinedev/refine/blob/main/packages/nestjsx-crud/src/utils/mapOperator.ts

[alicanerdurmaz]

Hello @dzcpy, It seems nestjsx-crud doesn't support array filters.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.