django queryset return single value

Question

I have the following -

obj.owner_id = Owner.objects.filter(owner_name=owner_obj).values_list('owner_id')[0]

Problem is the value it's returning is a tuple. Specifically this -

(786,)

All I want to return is the integer value or 786.

What am I doing wrong?

Have you tried doing Owner.objects.filter(owner_name='Operations').values_list('owner_id')[0][0]? — shaktimaan
– shaktimaan, Commented Sep 17, 2014 at 1:48
thanks that worked! Get another error now I'll make another question for it. — whoisearth
– whoisearth, Commented Sep 17, 2014 at 1:56
Try this Owner.objects.filter(owner_name='Operations').values_list('owner_id', flat=True)[0] — Alex Lisovoy
– Alex Lisovoy, Commented Sep 17, 2014 at 6:40

Dan Tao · Accepted Answer · 2018-06-29 14:48:08Z

For posterity, this also works and is (in my opinion) the cleanest option of all:

Owner.objects.values_list('owner_id', flat=True).get(owner_name=owner_obj)

Eugene Yarmash · Accepted Answer · 2019-07-30 12:53:36Z

Assuming owner_name is unique, either of these will do the trick:

owner_id = Owner.objects.only('owner_id').get(owner_name=owner_name).owner_id
owner_id = Owner.objects.values('owner_id').get(owner_name=owner_name)['owner_id']
owner_id = Owner.objects.values_list('owner_id', flat=True).get(owner_name=owner_name)

Documentation:

2 Answers 2