问题

我正在使用DRF的django-filter库。

```python
class OrganizationFilter(FilterSet):

    class Meta:
        model = Organization
        fields = {
            'city': ['iexact', 'contains'],
            'zipcode': ['exact', 'contains']
        }

city: CharField

我想对城市字段进行不区分大小写的过滤。

我可以通过指定以下方式使其工作。

class OrganizationFilter(FilterSet):
    city = filters.CharFilter(lookup_expr='iexact')
    ...

除非我指定lookup_expr，否则它不起作用。

我想知道为什么？

<details>
<summary>英文:</summary>

I am using django-filter lib with DRF.

```python
class OrganizationFilter(FilterSet):

    class Meta:
        model = Organization
        fields = {
            &#39;city&#39;: [&#39;iexact&#39;, &#39;contains&#39;],
            &#39;zipcode&#39;: [&#39;exact&#39;, &#39;contains&#39;]
        }

city: CharField

I want to filter city field case-insensitive.

I can make it work by specifying the following.

class OrganizationFilter(FilterSet):
    city = filters.CharFilter(lookup_expr='iexact')
    ...

Unless If I don't specify the lookup_expr it's not working.

I want to know why?

答案1

得分: 0

原因是，代码无法运行的原因是：

fields = {
    'city': ['iexact'],
    'zipcode': ['exact', 'contains']
}

是因为你在 'iexact' 旁边指定了 'contains'。Contains 将执行区分大小写的查找，这将与你的 iexact 查找冲突。所以你的代码应该是这样的：

class OrganizationFilter(FilterSet):
    class Meta:
        model = Organization
        fields = {
            'city': ['iexact'],
            'zipcode': ['exact', 'contains']
        }

fields = {
            'city': ['iexact', 'contains'],
            'zipcode': ['exact', 'contains']
        }

class OrganizationFilter(FilterSet):
    class Meta:
        model = Organization
        fields = {
            'city': ['iexact'],
            'zipcode': ['exact', 'contains']
        }