Can ordering feature cross relations?

[ddahan]

Hi there!

I used searching feature and was pleased to notice that search fields can cross relationships, for example with:

@searching(Searching, search_fields=["owner__first_name", "owner__last_name"])

However, I'm wondering how to have a similar behaviour with ordering feature.
As of now, it seems that it is considered to be a wrong field. For example, something like this will have no effect on ordering:

How can I do? Thanks a lot.

[eadwinCode]

@ddahan you mean you want searching query for and ordering action?

[ddahan]

Nope, I just want to be able to "order_by" across relation.

For example, this would work in a shell:

Badge.objects.order_by("owner__first_name")

But would not work (no effect on ordering) with my api call to :

http://localost:8000/api/badges?page=1&ordering=owner__first_name

[eadwinCode]

Oh okay I see what you mean. I will take a look and revert

[huangjiarong]

Has this bug been fixed?
I've added foreign key related fields to ordering_fields, so I can implement sorting for them.
However, this requires me to write all sortable fields into ordering_fields.

@router.get('/', response=List[SalarySchemaOut], summary='获取研发人员工资-分页')
@paginate(MyPagination)
@ordering(Ordering, ordering_fields=['research_staff_item__item_paper__name'])
def listData(request, filters: SalaryFilterSchema = Query(...)):
    """ 获取研发人员工资 """
    queryset = ResearchSalary.add_annotate()
    queryset = queryset.filter(research_staff_item__research_staff__company=request.company)\
        .prefetch_related("research_staff_item", "research_staff_item__research_staff", "research_staff_item__item_paper")
    queryset = filters.filter(queryset)
    return queryset