Home / Questions / 177007
Accepted
Piero Pajares
Asked: 2020-07-01 09:23:22 +0800 CST 2020-07-01 09:23:22 +0800 CST

Queryset with 2 fields from a table - Django Rest Framework

  • 772

I want to make a filter with 2 fields from the django user model first_name and last_name like this:

queryset = User.objects.annotate(search_name=Concat('first_name', Value(' '), 'last_name'))
queryset.filter(search_name__icontains='Prueba Pruebita')

But it is not returning the filter if not the entire list of users.

This is my serializer that just brings up most of the fields and the write-only password.

class UserSerializer(serializers.ModelSerializer):
    class Meta:
        model = User
        fields = ('id','username', 'password', 'first_name', 'last_name', 'email', 'code', 'phone')
        extra_kwargs = {'password': {'write_only': True}}

Am I missing something? or is there another way to make a filter with 2 fields of a model?

django

1 Answers

  1. Best Answer

    Somehow it works like this:

    fullname = request.data.get('full_name', None)
queryset = User.objects.all()
    if fullname:
        queryset = queryset.annotate(search_name=Concat('first_name', Value(' '), 'last_name'))
        queryset = queryset.filter(search_name__icontains=names)

    I hope it helps someone. :)

    • 0