該類Customer有一個類的外鍵User。我想返回此信息，但我不想在用戶名、名字等之前顯示 user__。data = {"customers": list(p.values("id", "user__username", "user__first_name", "user__last_name", "user__email", "phone", "address", "balance"))}我怎樣才能得到這樣的東西：{"customers": [ { "id": 12, "username": "leon2", "first_name": "lee", "last_name": "michalson", "email": "[email protected]", "phone": "042-22334455", "address": "Tehran, No.1", "balance": 20000 }]}
1 回答
慕萊塢森
TA貢獻1810條經驗 獲得超4個贊
使用注釋：
from django.db.models import F
for field in ('username', 'first_name', 'last_name', 'email'):
? ? p = p.annotate(**{field: F('user__' + field)})
data = {"customers": list(p.values("id", "username", "first_name",
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?"last_name", "email", "phone",
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?"address", "balance"))}
添加回答
舉報
0/150
提交
取消