You can annotate the queryset with first 5 letters of field2
using Substr
function:
from django.db.models.functions import Substr
queryset = Model.objects.all()
queryset = queryset.annotate(field2_5=Substr('field2', 1, 5))
And, then use the annotated field field2_5
in values:
values = queryset.values('field1', 'field2_5', 'field3')
与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…