更新时间:2023-02-27 14:18:46
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))
,然后在值中使用带注释的字段 field2_5
:
And, then use the annotated field field2_5
in values:
values = queryset.values('field1', 'field2_5', 'field3')