Have you tried using the *.query* on Django's QuerySet (documentation: [1])
For example, if my QuerySet is: *User.objects.filter(username__contains='alpha')* I can obtain the underlying raw SQL Query using: *print(User.objects.filter(username__contains='alpha').query)* *>>> *print(User.objects.filter(username__contains='alpha').query) SELECT `auth_user`.`id`, `auth_user`.`password`, `auth_user`.`last_login`, `auth_user`.`is_superuser`, `auth_user`.`username`, `auth_user`.`first_name`, `auth_user`.`last_name`, `auth_user`.`email`, `auth_user`.`is_staff`, `auth_user`.`is_active`, `auth_user`.`date_joined` FROM `auth_user` WHERE `auth_user`.`username` LIKE BINARY %alpha% 1: https://docs.djangoproject.com/en/2.2/topics/db/sql/#performing-raw-queries -- Regards Deep L Sukhwani On Wed, 25 Sep 2019 at 00:47, leb dev <[email protected]> wrote: > I now how to use django pagination with ORM django after filtering the > required data and put in into *pagination div* > > *queryset_list = employee.objects.all()* > *query=request.GET.get("q")* > * if query:* > * queryset_list=queryset_list.filter(* > * Q(name__icontains=query)|* > * Q(father_name__icontains=query)|* > * Q(mother_name__icontains=query)|* > * Q(content__icontains=query)|* > * Q(create_date__icontains=query)* > * # Q(user__first_name__contains=query)* > * ).distinct()* > > > * paginator = Paginator(queryset_list, 5)* > * page_request_var = "page"* > * page = request.GET.get(page_request_var)* > * queryset = paginator.get_page(page)* > > * context={* > * "object_list":queryset,* > * "title":"List Items",* > * "page_request_var":page_request_var,* > * }* > * return render(request,"blog/list.html", context)* > > > the above code is working > > my question is how to convert this ORM into raw SQL > > i know that i must use LIMIT and OFFSET in raw SQL to embedded into > paginator. > > > > -- > You received this message because you are subscribed to the Google Groups > "Django users" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To view this discussion on the web visit > https://groups.google.com/d/msgid/django-users/2d44b204-8520-423a-992c-597fd479f856%40googlegroups.com > <https://groups.google.com/d/msgid/django-users/2d44b204-8520-423a-992c-597fd479f856%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- You received this message because you are subscribed to the Google Groups "Django users" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/CAEMqiPc5zqcT%2BaPYSySLCJe22nPC-fCk_RkaTvWvRx5CSqkXQA%40mail.gmail.com.
