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, Jul 14 '22 at 07:48

score 2 · Accepted Answer · edited Jul 16 '22 at 16:38

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.

In Django Query set using filter with custom arguments

1 Answers1