Pass in parameters in django query

Question

Here is my case:

I have different types of users to share one general view, but I want return different fields for them. I used values() to specific fields, like this values('f1', 'f2'), and it returned the queryset.

Then, I wanted to use a variable to store the fields to query, and pass it in the values(), but failed. My snippets look like this:

list = ('f1', 'f2')
e = Entity.objects.all().values(list)

I tried tuple, list, str, but all failed.

Error msg:

object has no attribute 'split'

What is the correct way to get this function?

alecxe · Accepted Answer · 2014-03-30 06:23:53Z

2

You need to unpack the list:

fields = ('f1', 'f2')
e = Entity.objects.all().values(*fields)

Also, do not name a variable as list - it shadows built-in varaible type:

>>> a = list()
>>> a
[]
>>> list = ('f1', 'f2')
>>> a = list()
Traceback (most recent call last):
  File "<stdin>", line 1, in <module>
TypeError: 'tuple' object is not callable

Hope that helps.

answered Mar 30, 2014 at 6:23

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

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

1 Comment

Fred Wu Over a year ago

Thank you, it works, really helps me a lot. Actually, I use another name for the variable, just change to list for the question, I'll pay attention next time.

Collectives™ on Stack Overflow

Pass in parameters in django query

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related