How to extract Data from Django Queryset

Question

How to retrieve the data from Django queryset for use in a variable

When an output is received in below form after running the query

<QuerySet [{'name': 'John'}]>

I want to use the value 'John' in a variable for further processing.

How do I extract this ?

But this is a collection of values, so it is, stricty speaking possible that this queryset contains zero, one, or more entries. If you filter such that there is always exactly one element, you should use Model.objects.get(pk=my_pk). — willeM_ Van Onsem
– willeM_ Van Onsem, Commented Feb 21, 2019 at 20:01
Thanks Willem, So I am using filter and it may get me more than one names. So given the above format of output, How do I get the names out of it ? — Vaibhav Mishra
– Vaibhav Mishra, Commented Feb 21, 2019 at 20:10

dKen · Accepted Answer · 2022-04-20 11:50:18Z

5

k = <QuerySet [{'name': 'John'}]>
k[0] = {'name': 'John'}

Queryset is a list.

edited Apr 20, 2022 at 11:50

dKen

3,1471 gold badge30 silver badges39 bronze badges

answered Feb 21, 2019 at 20:50

biswa1991

5764 silver badges8 bronze badges

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

Comments

4b0 · Accepted Answer · 2021-03-16 03:36:26Z

2

Try with values_list().

myValues = myQuerySet.values_list()

edited Mar 16, 2021 at 3:36

4b0

22.4k30 gold badges97 silver badges143 bronze badges

answered Mar 16, 2021 at 3:31

Sandy

564 bronze badges

Comments

President James K. Polk · Accepted Answer · 2025-05-07 00:51:18Z

0

One way to do is to use a for loop:

>>> names = Student.objects.filter(first_name__in=['Varun', 'Gina'])
>>> names
<QuerySet [<Student: Varun Sharma>, <Student: Gina Ram>]>
>>> for name in names:
...     print(name)
...

edited May 7 at 0:51

President James K. Polk

42.3k34 gold badges113 silver badges149 bronze badges

answered May 6 at 13:45

Ghazi Shakoor

12 bronze badges

2 Comments

Community May 6 at 20:30

As it’s currently written, your answer is unclear. Please edit to add additional details that will help others understand how this addresses the question asked. You can find more information on how to write good answers in the help center.

Community May 7 at 12:13

Your answer could be improved with additional supporting information. Please edit to add further details, such as citations or documentation, so that others can confirm that your answer is correct. You can find more information on how to write good answers in the help center.

Collectives™ on Stack Overflow

How to extract Data from Django Queryset

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related