Pass list of fields to QuerySet.values( )

Question

Is there a way I can pass a list of fields to be retrieved by the QuerySet.values(). I have a model and I want to retrieve different sets of fields from it on different occasions.

dokkaebi · Accepted Answer · 2015-02-27 22:07:05Z

39

You can use the * operator to expand a list out into separate arguments when passed to a function, as described here in the Python tutorial.

>>> qs = User.objects.all()
>>> values = ['first_name', 'email']
>>> qs.values(*values)

yields

[{'first_name': u'aaaa', 'email': u'[email protected]'}, 
 {'first_name': u'', 'email': u'[email protected]'}, 
 {'first_name': u'', 'email': u'[email protected]'},
 '...(remaining elements truncated)...']

(I further truncated the output for brevity).

edited Feb 27, 2015 at 22:07

answered Oct 5, 2012 at 7:01

dokkaebi

9,2003 gold badges46 silver badges60 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

alexsalo Over a year ago

Brilliant! Could you please briefly explain why * works here?

dokkaebi Over a year ago

@alexsalo That's a built-in python feature. I've added a link to the docs in my answer.

Collectives™ on Stack Overflow

Pass list of fields to QuerySet.values( )

1 Answer 1

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related