Django queryset with variable value

Question

I am writing dynamic filters in django for my database where I am using the below code where I have 2 variables(p_type,s_type):

        p_type=[]
        s_type=[]
        query = request.GET.get("q")
        p_type =request.GET.get("p_type")
        s_type = request.GET.get("s_type")
        #messages.add_message(request, messages.INFO, p_type)
        #messages.add_message(request, messages.INFO, s_type)
        if query:
            queryset_find = queryset_list.filter(
                Q(FP_Item__contains=query))
            context = {'object_list': queryset_find}
            return render(request, 'index.html', context)
        elif p_type:
            queryset_find = queryset_list.filter(
                Q(p_type__contains=s_type))
            context = {'object_list': queryset_find}
            return render(request, 'index.html', context)
        else:
            context = {'object_list': queryset}
            return render(request, 'index.html', context)

but django returns error at below line

Q(p_type__contains=s_type))

I have dynamic radio button where the value of p_type matches with my database but even though I am receiving the following error:

Exception Type: FieldError
Exception Value:    
Cannot resolve keyword 'p_type' into field. Choices are: ... (same choices which I am using with my database).

Isn't it doable with variable query ? Any other methods ?

model:

class RFP(models.Model):
    FP_Item = models.TextField(max_length=1500)
    P_63 = models.TextField(max_length=1000)
    P_64 = models.TextField(max_length=1000)

I get the error FieldError at /fp/ Cannot resolve keyword 'p_type' into field. Choices are: P_63, P_64 etc.. — İlkem Çetinkaya
– İlkem Çetinkaya, Commented Apr 30, 2018 at 10:47
please show your model. I assume, you filter not the queryset, that you need. — Sergiy Miletskyi
– Sergiy Miletskyi, Commented Apr 30, 2018 at 12:35

Will Keeling · Accepted Answer · 2018-04-30 15:22:51Z

4

If p_type holds the name of the field you want to query, then you can do:

elif p_type:
    kwargs = {
        '{}__contains'.format(p_type): s_type
    }
    queryset_find = queryset_list.filter(Q(**kwargs))
    ...

edited Apr 30, 2018 at 15:22

answered Apr 30, 2018 at 14:48

Will Keeling

23.1k4 gold badges58 silver badges64 bronze badges

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

1 Comment

İlkem Çetinkaya Over a year ago

I also found another solution that can be used as per below: queryset_find = queryset_list.filter( Q(**{p_type: s_type}))

Collectives™ on Stack Overflow

Django queryset with variable value

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