from django.http import JsonResponse
from .models import YourModel

def your_datatable_view(request):
 # Get parameters from the request
 start = int(request.GET.get("start", 0))
 length = int(request.GET.get("length", 10))
 search_value = request.GET.get("search[value]", "")
 order_column = request.GET.get("order[0][column]", "0") # Default to first column
 order_dir = request.GET.get("order[0][dir]", "asc") # Default to ascending

 # Filter the queryset based on the search value
 queryset = YourModel.objects.all()
 if search_value:
 queryset = queryset.filter(your_field__icontains=search_value)

 # Order the queryset
 if order_dir == "asc":
 queryset = queryset.order_by(order_column)
 else:
 queryset = queryset.order_by("-" + order_column)

 # Paginate the queryset
 total_records = queryset.count()
 queryset = queryset[start:start + length]

 # Prepare the response data
 data = {
 "draw": int(request.GET.get("draw", 1)),
 "recordsTotal": total_records,
 "recordsFiltered": total_records, # Adjust this if you have a separate count for filtered records
 "data": list(queryset.values()), # Convert queryset to list of dictionaries
 }

 return JsonResponse(data)

$(document).ready(function() {
 $("#yourTableId").DataTable({
 "processing": true,
 "serverSide": true,
 "ajax": {
 "url": "/your-datatable-url/",
 "type": "GET"
 },
 // Additional DataTable options...
 });
});