Skip to main content
Version: 3.xx.xx

Handling Filters

refine expects an array of type CrudFilters to filter results based on some field’s values. So you can use more than one filter. Even the or operator can be used to combine multiple filters.

CrudFilters

CrudFilters is an array of objects with the following properties:

// Supported operators:
type CrudOperators =
    | "eq"
    | "ne"
    | "lt"
    | "gt"
    | "lte"
    | "gte"
    | "in"
    | "nin"
    | "contains"
    | "ncontains"
    | "containss"
    | "ncontainss"
    | "between"
    | "nbetween"
    | "null"
    | "nnull"
    | "or";

// Supported filter types:
type LogicalFilter = {
    field: string;
    operator: Exclude<CrudOperators, "or">;
    value: any;
};

type ConditionalFilter = {
    operator: "or";
    value: LogicalFilter[];
};

type CrudFilter = LogicalFilter | ConditionalFilter;
type CrudFilters = CrudFilter[];

LogicalFilters

LogicalFilter works with AND logic. For example, if you want to filter by name field and age field, you can use the following filter:

const filter = [
    {
        field: "name",
        operator: "eq",
        value: "John",
    },
    {
        field: "age",
        operator: "lt",
        value: 30,
    },
];

Here the query will look like: "name" = "John" AND "age" < 30

ConditionalFilters

ConditionalFilter works only with or operator and expects an array of LogicalFilter objects in the value property. For example, if you want to filter by age field or createdAt field, you can use the following filter:

const filter = [
    {
        operator: "or",
        value: [
            {
                field: "age",
                operator: "eq",
                value: 30,
            },
            {
                field: "createdAt",
                operator: "gte",
                value: "2018-01-01",
            },
        ],
    },
];

Here the query will look like: "age" = 30 OR "createdAt" <= "2018-01-01"

Combining Filters

You can group multiple parameters in the same query using the logical filters or the conditional filters operators to filter results based on more than one criteria at the same time. This allows you to create more complex queries.

Example query: Find posts with 2 possible dates & a specific status

filter = [
    {
        operator: "or",
        value: [
            {
                field: "createdAt",
                operator: "eq",
                value: "2022-01-01",
            },
            {
                field: "createdAt",
                operator: "eq",
                value: "2022-01-02",
            },
        ],
    },
    {
        operator: "eq",
        field: "status",
        value: "published",
    },
];

Here the query will look like:
"status" == "published" AND ("createdAt" == "2022-01-01" OR "createdAt" == "2022-01-02")

Handle filters in a data provider

dataProvider.ts
import { DataProvider } from "@pankod/refine-core";

const dataProvider = (): DataProvider => ({
    getList: async ({ resource, pagination, filters, sort }) => {
        if (filters) {
            filters.map((filter) => {
                if (filter.operator !== "or") {
                    // Handle your logical filters here
                    // console.log(typeof filter); // LogicalFilter
                } else {
                    // Handle your conditional filters here
                    // console.log(typeof filter); // ConditionalFilter
                }
            });
        }
    },
});
tip

Data providers that support or and and filtering logic are as follows: