Django how to get something by foreign key' value?

Question

I have a model:

from django.contrib.auth.models import User

# Create your models here.
class Strategy(models.Model):
    user = models.ForeignKey(User, on_delete=models.CASCADE)
    mod_date = models.DateTimeField(auto_now=True)
    strategy_name = models.CharField(max_length=20)
    strategy = models.TextField()
    position = models.TextField()

I want to get username = "leo".

But in Strategy's user is using user_id.

How to get "models.Strategy.objects.get" or "models.Strategy.objects.filter" using username = "leo"?

Thank you.

Possible duplicate of [Django models filter by foreignkey](http://stackoverflow.com/questions/11508744/django-models-filter-by-foreignkey) — Sardorbek Imomaliev, Feb 20 '17 at 05:41

score 3 · Answer 1 · edited May 23 '17 at 10:29

3

Duplicated question Django models filter by foreignkey

Strategy.objects.filter(user__username='leo').first()

or

try:
    Strategy.objects.get(user__username='leo')
except Strategy.DoesNotExists():
    print 'username Leo does not exists'

Documentation

edited May 23 '17 at 10:29

Community

1
1

answered Feb 20 '17 at 02:14

alfredo138923

1,509
1
15
15

Django how to get something by foreign key' value?

1 Answers1