[Django]-Django models | get specific columns

78👍

QuerySet.values() or QuerySet.values_list(), e.g.:

Entry.objects.values('first_name')

24👍

If you want a list of only the values, use:

Entry.objects.values_list('first_name', flat=True)

3👍

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

Leave a comment