Django Rest Framework CharFilter JSON

debugcn 发表于 Dev

普里兹拉克米尔

我在django rest中有一个过滤器charfilterinfilter（field_name ='genres__name'，lookup_expr ='in'）。我在数据库中有通过多对多处理的两个类别，但是在过滤该产品的两个类别时却有有两个要素，我只需要一个要素

意见

class CharFilterInFilter(filters.BaseInFilter, filters.CharFilter):
    pass

class ShoppFilter(filters.FilterSet):
    price = filters.RangeFilter()
    genres = CharFilterInFilter(field_name='genres__name')
    title = SearchFilter()
    class Meta:
        model = smartphone
        fields = ['price','genres','title']


class MDShopListView(generics.ListAPIView):
    queryset = smartphone.objects.all()
    filter_backends = (DjangoFilterBackend,SearchFilter)
    search_fields = ['title']
    filterset_class = ShoppFilter



def get(self, request):
    queryset = self.filter_queryset(self.get_queryset())
    serializer=MDShopListSerializer(queryset,many=True)
    return Response(serializer.data)

楷模

genres = models.ManyToManyField(Genre, verbose_name="жанры")


class Genre(models.Model):
   [enter image description here][1]
    name = models.CharField("Имя", max_length=100)

img json 1：https：//i.stack.imgur.com/4WR6L.png

埃敏·马斯蒂扎达（Emin Mastizada）

这是ManyToMany字段的常见问题，解决方案是将distinct方法应用于查询：

class ShoppFilter(filters.FilterSet):
    ...your filter definition as it is now

    def filter_queryset(self, request, queryset, view):
        return super(ShoppFilter, self).filter_queryset(
            request, queryset, view
        ).distinct()

本文收集自互联网，转载请注明来源。

如有侵权，请联系[email protected] 删除。