In Django Query set using filter with custom arguments

Question

I am using the filter in Django queryset, as it takes arguments like:

Model.objects.filter(name="Amit")

here is name and it's value, I am getting from the request of API:

def get(self, request):
    column = request.query_params.get('column')
    val = request.query_params.get('value')
    query = Data.objects.filter(column=val).values()
    serializer = DataSerializer(query, many=True).data
    return Response(serializer)

but here column [inside filter] is not getting recognized as the request parameter, it is taken as the column name of the table which is not available.

The error I got:

django.core.exceptions.FieldError: Cannot resolve keyword 'column' into field.

Hope this information is suitable for understanding the problem, if something is missing please let me know and kindly help me out with this.

Can you share your models please, the error means column isn't a field in your table. — Sorin Burghiu
– Sorin Burghiu, Commented Jul 14, 2022 at 7:48

marc_s · Accepted Answer · 2022-07-16 16:38:45Z

2

You can try this: django-query-filter-with-variable-column

So if column is a variable containing which field you want to filter then it should be like this:

def get(self, request):
    column = request.query_params.get('column')
    val = request.query_params.get('value')
    query = Data.objects.filter(**{column:val}).values()
    serializer = DataSerializer(query, many=True).data
    return Response(serializer)

and you should check if column or val is not None for prevent error.

edited Jul 16, 2022 at 16:38

marc_s

760k186 gold badges1.4k silver badges1.5k bronze badges

answered Jul 14, 2022 at 10:51

Nguyen Long Nhat

514 bronze badges

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

Collectives™ on Stack Overflow

In Django Query set using filter with custom arguments

1 Answer 1

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related