Python3.x 按字母顺序排序列表 (OrderFilter)，条件是值为 '' 的条目位于列表 DRF 的末尾

您可以使用Django ORM Coalesce函数

from django.db.models import Case, When
from django.db.models.functions import Coalesce

def order_by_custom_fields(self, ordering: list):
    order_by_fields = []
    for field in ordering:
        if field == 'field':
            order_by_fields.append(Coalesce('field', ''))  # replace empty string with null
            order_by_fields.append('-field')  # add descending order by field
    return order_by_fields

def get_ordering(self, request, queryset, view):
    params = request.query_params.get(self.ordering_param)
    if params:
        fields = [param.strip() for param in params.split(',')]
        ordering = self.remove_invalid_fields(queryset, fields, view, request)
    else:
        ordering = []
    ordering.extend(self.order_by_custom_fields(ordering))
    return tuple(self.filters_custom_ordering(ordering))

def filter_queryset(self, request, queryset, view):
    ordering = self.get_ordering(request, queryset, view)
    if ordering:
        return queryset.order_by(*ordering)
    return queryset

您需要将数据库中的字段从''更改为null，或者使用不同的值而不是''来表示空字段，例如'-'.

您可以将ORDER_BY_CUSTOM_FIELS方法修改为对ORDER_BY方法使用nulls_last=True选项，如下所示:

from django.db.models import Case, When
from django.db.models.functions import Coalesce

def order_by_custom_fields(self, ordering: list):
    result = []
    for field in ('field'):
        if field in ordering:
            result.append(Case(
                When(field='', then=None),
                default=field,
                output_field=CharField()
            ))
    result.append(Coalesce('field', '')) # Using Coalesce to sort empty fields last
    result.append('id') # Can add additional field to break ties
    return result