Django models | get specific columns
Is there a way to filter and get only specific c开发者_Go百科olumns?
For example, get all entries with the column first_name
.
QuerySet.values()
or QuerySet.values_list()
, e.g.:
Entry.objects.values('first_name')
If you want a list of only the values, use:
Entry.objects.values_list('first_name', flat=True)
To only get a column's values from the table but still return an object of that model, use only
:
record = Entry.objects.only('first_name')
This will defer all other columns from the model but you can still access them all normally.
record.first_name # already retrieved
record.last_name # retrieved on call
精彩评论