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 django-users+unsubscribe@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/django-users/2d44b204-8520-423a-992c-597fd479f856%40googlegroups.com.
No comments:
Post a Comment