如何从多个领域进行搜索？ [英] How to search from many fields?

问题描述

我对视图集有自定义过滤器：

I have custom filter to my viewset:

class OrderFilter(django_filters.rest_framework.FilterSet):
    username = django_filters.CharFilter(name='user__username', lookup_expr='icontains')
    client_name = django_filters.CharFilter(name='user__first_name', lookup_expr='icontains')

    class Meta:
        model = Order
        exclude = ['pk']

当我发送这样的查询时它起作用：

And it works when I send query like this:

http://localhost:8000/orders/?username=testuser

或

http://localhost:8000/orders/?client_name=john

但是我只想创建一个查询来搜索包含用户名， first_name 和中的搜索字符串的数据last_name 。

but I want to create only one query to search data containing search string in username, first_name and last_name. How to do it?

推荐答案

对于无法由单个过滤器表示的复杂行为，通用方法是：对过滤器类使用方法参数（文档）。

The general catch-all for complicated behavior that can't be expressed by a single filter is to use the method argument to a filter class (docs).

可能的实现：

from django_filters import rest_framework as filters
from django.db.models import Q


class OrderFilter(filters.FilterSet):
    search = filters.CharFilter(method='search_filter')

    def search_filter(self, queryset, name, value):
        return queryset.filter(Q(username__icontains=value) 
                               | Q(first_name__icontains=value) 
                               | Q(last_name__icontains=value))

这篇关于如何从多个领域进行搜索？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！