How to obtain a QuerySet of all rows with specific fields for each one of them

Question

I have a model Employees and I would like to have a QuerySet of all rows  but with some specific fields from each row  and not all fields  I know how to query all rows from the table model  Employees objects all    I would like to know how to select fields for each of the Queryset element  How can I do that

User · Answer

In addition to values list as Daniel mentions you can also use only  or defer for the opposite effect  to get a queryset of objects only having their id and specified fields   Employees objects only  eng name     This will run a single query   SELECT id  eng name FROM employees

User · Answer

We can select required fields over values   Employee objects all   values  eng name   rank

User · Answer

Oskar Persson s answer is the best way to handle it because makes it easier to pass the data to the context and treat it normally from the template as we get the object instances  easily iterable to get props  instead of a plain value list   After that you can just easily get the wanted prop   for employee in employees      print employee eng name    Or in the template      for employee in employees          lt p gt    employee eng name    lt  p gt      endfor

User · Answer

You can use values list alongside filter like so   active emps first name   Employees objects filter active True  values list  first name  flat True    More details here

User · Answer

Daniel answer is right on the spot  If you want to query more than one field do this  Employee objects values list  eng name   rank    This will return list of tuples  You cannot use named Ture when querying more than one field  Moreover if you know that only one field exists with that info and you know the pk id then do this  Employee objects values list  eng name   rank   get pk 1

User · Answer

Employees objects values list  eng name   flat True    That creates a flat list of all eng names  If you want more than one field per row  you can t do a flat list  this will create a list of tuples   Employees objects values list  eng name    rank

[python] How to obtain a QuerySet of all rows, with specific fields for each one of them?

Examples related to python

Examples related to django

Examples related to django-models

Examples related to django-queryset