Django:Getting List of values from query set

Question

I have the following query

country=employees.objects.filter(manager_id__emp_id=111).values('emp_loc').distinct()

I get Output as <QuerySet [{'emp_loc': 'IND'}, {'emp_loc': 'MLA'}]>

But I need list

['IND','MLA']

How Can I do it?

hspandher · Accepted Answer · 2017-11-09 13:18:23Z

11

Use values_list instead.

country=employees.objects.filter(manager_id__emp_id=111).values_list('emp_loc', flat=True).distinct()

answered Nov 9, 2017 at 13:18

hspandher

16.8k2 gold badges35 silver badges49 bronze badges

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

Comments

David Buck · Accepted Answer · 2021-03-12 11:39:29Z

0

As an alternative suggestion:

country = [ list(elem) for elem in list(employees.objects.filter(manager_id__emp_id=111).values_list('emp_loc', flat=True).distinct()]

David Buck

3,88840 gold badges54 silver badges74 bronze badges

answered Oct 28, 2020 at 17:31

Sriram S

594 bronze badges

Could you please provide some context as to how your solution works and why it might be better than others?