这是一个稍微不同的解决方案--不是过滤空值，而是过滤器的替代品。OrderingFilter总是确保它们排序在最后：

class NullsAlwaysLastOrderingFilter(filters.OrderingFilter):
    """ Use Django 1.11 nulls_last feature to force nulls to bottom in all orderings. """
    def filter_queryset(self, request, queryset, view):
        ordering = self.get_ordering(request, queryset, view)

        if ordering:
            f_ordering = []
            for o in ordering:
                if not o:
                    continue
                if o[0] == '-':
                    f_ordering.append(F(o[1:]).desc(nulls_last=True))
                else:
                    f_ordering.append(F(o).asc(nulls_last=True))

            return queryset.order_by(*f_ordering)

        return queryset

您可以自定义自己的OrderingFilter：

# Created by BaiJiFeiLong@gmail.com at 2022/8/13
from django.db.models import F, OrderBy
from django_filters import rest_framework as filters

class MyOrderingFilter(filters.OrderingFilter):
    def get_ordering_value(self, param):
        value = super().get_ordering_value(param)
        return OrderBy(F(value.lstrip("-")), descending=value.startswith("-"), nulls_last=True)

排序将排除空值，假设您的字段名为stats，您可以执行以下操作：

Stats.objects.exclude(stats__isnull=True).exclude(stats__exact='')

BaiJiFeiLong's solution几乎对我有用。经过一些调整，它最终达到了目的：

from django.db.models import F, OrderBy
from rest_framework.filters import OrderingFilter

class NullsLastOrderingFilter(OrderingFilter):

def get_ordering(self, request, queryset, view):
    values = super().get_ordering(request, queryset, view)
    return (OrderBy(F(value.lstrip("-")), descending=value.startswith("-"), nulls_last=True) for value in values)