如何根据Django-Rest-framework中的某个参数获取最新记录

发布于 2025-02-08 10:08:36 字数 889 浏览 0 评论 0原文

我正在尝试Fetch 最新基于参数记录，但是当使用（最新（），last（），emalt（），order_by（' - id'）[0] [0]，最新（' - - - - id'））QuerySet中的所有这些方法，然后我有空记录，请帮助我。

@api_view(['GET'])
@permission_classes((IsAuthenticated,))
def details(request):
    if request.method == 'GET':
        category=request.query_params.get('category')
        name=request.query_params.get('name')
        try:
            d=Employee.objects.filter(category=category,name=name).latest()
            response_data=EmployeeSerializer(d,many=True).data
            return JsonResponse({"message": "detail retrieval","error":False,"code":200,"results":{"totalItems":d.count(),"pageData":response_data,"totalPages":1,"currentPage":0}}, status=HTTP_200_OK)
        except:
            return JsonResponse({"message": "details not exist","error":True,"code":200,"results":{}}, status=HTTP_200_OK)

原文

i am trying fetch latest record based on parameter but when use( latest(), last(), earliest(), order_by('-id')[0], latest('-id') )all this method in queryset then i got empty record, please help me out.

@api_view(['GET'])
@permission_classes((IsAuthenticated,))
def details(request):
    if request.method == 'GET':
        category=request.query_params.get('category')
        name=request.query_params.get('name')
        try:
            d=Employee.objects.filter(category=category,name=name).latest()
            response_data=EmployeeSerializer(d,many=True).data
            return JsonResponse({"message": "detail retrieval","error":False,"code":200,"results":{"totalItems":d.count(),"pageData":response_data,"totalPages":1,"currentPage":0}}, status=HTTP_200_OK)
        except:
            return JsonResponse({"message": "details not exist","error":True,"code":200,"results":{}}, status=HTTP_200_OK)

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

九歌凝 2025-02-15 10:08:36

@api_view(['GET'])
@permission_classes((IsAuthenticated,))
def details(request):
    if request.method == 'GET':
        category=request.query_params.get('category')
        name=request.query_params.get('name')
        try:
            d=Employee.objects.filter(category=category,name=name).latest('id')
            serializer=EmployeeSerializer(d)
            return JsonResponse({"message": "detail retrieval","error":False,"code":200,"results":{"totalItems":d.count(),"pageData":serializer.data,"totalPages":1,"currentPage":0}}, status=HTTP_200_OK)
        except:
            return JsonResponse({"message": "details not exist","error":True,"code":200,"results":{}}, status=HTTP_200_OK)

@api_view(['GET'])
@permission_classes((IsAuthenticated,))
def details(request):
    if request.method == 'GET':
        category=request.query_params.get('category')
        name=request.query_params.get('name')
        try:
            d=Employee.objects.filter(category=category,name=name).latest('id')
            serializer=EmployeeSerializer(d)
            return JsonResponse({"message": "detail retrieval","error":False,"code":200,"results":{"totalItems":d.count(),"pageData":serializer.data,"totalPages":1,"currentPage":0}}, status=HTTP_200_OK)
        except:
            return JsonResponse({"message": "details not exist","error":True,"code":200,"results":{}}, status=HTTP_200_OK)

回复收藏 0 原文

~没有更多了~