How to extract values from Queryset Django

Question

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

<QuerySet [<key: value object (ad5bb6b4-8035)>]>

I want to get ad5bb6b4-8035 string only for further operations.

So I tried

course_qs =  <QuerySet [<key: value object (ad5bb6b4-8035)>]>
for course in course_qs:
    print(course)

which returned

value object (ad5bb6b4-8035)

How to get only ad5bb6b4-8035.?

getting values of QuerySet in django How to extract numerical value from Django queryset? Extracting message from django queryset

You can also see all the object value under its dict attribute. See if its in there — GabrielBoehme
– GabrielBoehme, Commented Sep 23, 2022 at 0:08

Mahammadhusain kadiwala · Accepted Answer · 2022-09-25 12:42:17Z

0

values() is extract key,value for the specific column from queryset it's return list of dictionaries.

value1 = User.objects.all().values('username')
    
    #output = <QuerySet [{'username': 'one'}, {'username': 'three'}, {'username': 'two'}]>

values_list() is extract only values for the specific column from queryset it's return list of tuples.

value2 = User.objects.all().values_list('username')

#output = <QuerySet [('one',), ('three',), ('two',)]>

edited Sep 25, 2022 at 12:42

answered Sep 23, 2022 at 9:23

Mahammadhusain kadiwala

3,6702 gold badges9 silver badges17 bronze badges

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

2 Comments

Mark Rotteveel Over a year ago

Please don't post only code as answer, but also provide an explanation what your code does and how it solves the problem of the question. Answers with an explanation are usually more helpful and of better quality, and are more likely to attract upvotes.

Mahammadhusain kadiwala Over a year ago

I explained in answer check it out.

Collectives™ on Stack Overflow

How to extract values from Queryset Django

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related