[Fixed]-How to concatenate two model fields in a Django QuerySet?


looks like you need concat:

from django.db.models import CharField, Value
from django.db.models.functions import Concat

query = DataTable.objects.annotate(C=Concat('A', 
          Value('-'), 'B', output_field=CharField()))


Basically there are two approaches to achieve it.

First one:
First of all, you need to import the following expressions.

from django.db.models import F, Value, Func

then, concatenate the fields as below:

ann_concat = Customer.objects.annotate(
            fullName = Func(F('first_name'), Value(' '),F('last_name'), function= 'CONCAT'))

In above example, I have concatenated first name and last name into a new field called fullName.

Second one:
This approach is way shorter than the first one you only need to import Concat() and Value() for making the spaces functions.

from django.db.models.functions import Concat

  short_syntax = Customer.objects.annotate(full_name = Concat('first_name',Value(' '),'last_name'))


You can do so with Value() and of course Concat django

Value is to set the white space or -, try the following:

from django.db.models import Value, CharField
from django.db.models.functions import Concat

def Test(request):
     query = DataTable.objects.annotate(C=Concat('A',Value('-') ,'B',
      # the rest of the function...

Leave a comment