Django过滤器'__in'查找 [英] Django-filter '__in' lookup

问题描述

我正在将django-rest-framework与 https://github.com/alex/django- filter / ，但问题主要是关于django-filter。我不明白如何在 __in查询中使用过滤器。

I am using django-rest-framework with https://github.com/alex/django-filter/, but question is mostly about django-filter. I can't understand how to use filters with "__in" lookup.

例如，我有以下模型：

class Book(models.Model):
   name = models.CharField(max_length=100)

class BookView(viewsets.ReadOnlyModelViewSet):
   serializer_class = BookSerializer()
   model = Book
   filter_fields = ('id', 'name')

而且我不能使用这样的网址

And i can't use url like this

/ v1 / books /？id__in = 1,2 ，3

/v1/books/?id__in=1,2,3

查找ID为1、2或3的书

to find books with id 1, 2 or 3

推荐答案

在本期中讨论问题： https://github.com/alex/django-filter/issues/137#issuecomment-77697870

建议的解决方案是创建自定义过滤器如下：

The suggested solution would be to create a custom filter as follows:

from django_filters import Filter
from django_filters.fields import Lookup

from .models import Product

class ListFilter(Filter):
    def filter(self, qs, value):
        value_list = value.split(u',')
        return super(ListFilter, self).filter(qs, Lookup(value_list, 'in'))

class ProductFilterSet(django_filters.FilterSet):
    id = ListFilter(name='id')

    class Meta:
        model = Product
        fields = ['id']

您可以编写以下内容：

products /？id = 7,8,9

products/?id=7,8,9

这篇关于Django过滤器'__in'查找的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！