Django, pass a javascript variable into ListView to filter a queryset

Question

I'd like to use an Ajax variable within a Django Class based ListView.

Getting the variable into the view is no problem using request.GET.get however, it seems by doing so, I am put into a dilemma.

If I am using def get(self, request) I then have problem using get_queryset and get_context

If I skip using def get(self, request) I have problem getting the Ajax variable into the view.

I'd like to ask for some help to get it working. The ultimate aim is to produce a filtered context that will be used to produce an email.

class ProductListSendView(LoginRequiredMixin, ListView):
    model = Product
    template = 'product/product_email.html'
    
    def get(self, request):
        _req_list =  json.loads(request.GET.get('ids', None))
        _res = [int(i) for i in _req_list]
        return _res
  
    def get_queryset(self, _res):
        queryset = super(ProductListSendView, self).get_queryset()
        qs = queryset.filter(id__in=_res)
        return qs

    def get_context_data(self):
        context = super(ProductListSendView, self).get_context_data()
        context['page_title'] = 'Authors'
        self.send_email(context)
        return context

the js function (for completeness)

var getProducts = function () {
    var table = $('#product_list-table').DataTable();
    var ids = $.map(table.rows('.selected').data(), function (item) {
    return item[1]});


jQuery.ajax({
    type: 'GET',
    url: "/product/list/send/",
    data: { 
        ids: JSON.stringify(ids),
                },
    success: function(data) {},
    error: function(xhr, textStatus, error) {
        console.log(error);  
   } 
});
};

Eugene Prikazchikov · Accepted Answer · 2020-10-25 14:08:47Z

1

You can override get_queryset and access request from there using self.request:

    def get_queryset(self):
        _req_list =  json.loads(self.request.GET.get('ids', None))
        _ids = [int(i) for i in _req_list]
        queryset = super(ProductListSendView, self).get_queryset()
        qs = queryset.filter(id__in=_ids)
        return qs

If you need to access _ids not only from get_queryset, but also from get_context_data, then you can store it on self in get method, and then call super to proceed with usual processing:

    def get(self, request):
        _req_list =  json.loads(request.GET.get('ids', None))
        self._ids = [int(i) for i in _req_list]
        return super().get(request)

Of course, if you do that, then in get_queryset and in get_context_data you should acess it through self._ids

edited Oct 25, 2020 at 14:08

answered Oct 25, 2020 at 13:57

Eugene Prikazchikov

1,9341 gold badge16 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Eugene Prikazchikov Over a year ago

oops, this is typo, I updated it. get_queryset does not take any parameters.

Collectives™ on Stack Overflow

Django, pass a javascript variable into ListView to filter a queryset

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related