Django 5.0.2：TypeError：获取切片后无法过滤查询

发布于03月01日

为什么不管用？我得到错误"Cannot filter a query once a slice has been taken." 我能做些什么来解决这个问题？

class LogbookLastViewSet(viewsets.ReadOnlyModelViewSet):
    serializer_class = LogbookSerializer
    permission_classes = [permissions.IsAuthenticated]
    filterset_fields = ['organizationID']
    
    def get_queryset(self):
        queryset = Logbook.objects.filter(organizationID='1111').order_by('-created')[:10]
        return queryset

我需要这样的东西:

SELECT * FROM logbook WHERE organizationID='1111' ORDER_BY created LIMIT 10;

推荐答案

这要归功于filterset_fields.这样的过滤将发生在.get_queryset(…) ^[drf-doc]的after处，但由于您对get_queryset进行切分，因此不可能进行额外的过滤.

您可以改为在.paginate_queryset(…)中进行切片:

class LogbookLastViewSet(viewsets.ReadOnlyModelViewSet):
    serializer_class = LogbookSerializer
    permission_classes = [permissions.IsAuthenticated]
    filterset_fields = ['organizationID']
    queryset = Logbook.objects.all()

    def paginate_queryset(self, queryset):
        return queryset[:10]