在Django中,如何按日期降序排序查询集?
Reserved.objects.all().filter(client=client_id).order_by('check_in')
我只想按照check_in日期从大到小筛选所有保留的项。
Reserved.objects.filter(client=client_id).earliest('check_in')
Reserved.objects.filter(client=client_id).latest('-check_in')
earliest()
和 latest()
的文档。Staffs.objects.filter(active=1).order_by('rank')
-(连字符)用于表示降序。
这对我来说是有效的。
latestsetuplist = SetupTemplate.objects.order_by('-creationTime')[:10][::1]
按升序排序:
结构:
Model.objects.filter(model_column_name=model_column_value).order_by(expected_column_name as string)
例子:
Employee.objects.filter(department=department_id).order_by('salary')
按降序排序:
结构:
Model.objects.filter(model_column_name=model_column_value).order_by(-expected_column_name as string)
例子:
Employee.objects.filter(department=department_id).order_by('-salary')