时间戳

首页 > 解决方案 > Django 休息框架 charfilter json

json - Django 休息框架 charfilter json

问题描述

我在 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

标签： jsondjangodjango-rest-framework

解决方案

在这里改变和工作
queryset = self.filter_queryset(self.get_queryset()).distinct()

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

class ShoppFilter(filters.FilterSet):
    price = filters.RangeFilter()
    genres = CharFilterInFilter(field_name='genres__name', lookup_expr='in')
    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()).distinct()
        serializer=MDShopListSerializer(queryset,many=True)
        return Response(serializer.data)

推荐阅读