Filtering query with a foreign key

Question

I have the following Models:

class Categories(models.Model):
    name = models.CharField(max_length=200, unique=True)

class Funnies(models.Model):
    title = models.CharField(max_length=200)
    category = models.ForeignKey(Categories)

In a case where I have a variable holding a category name (myVar), instead of getting all rows in Funnies that hold a reference to the category the long way:

category_id = Categories.objects.get(name = myVar)
funnies_list = Funnies.objects.filter(category = category_id)

Is there a shorter, more "django" way of getting funnies_list ?

Meir

JamesO · Accepted Answer · 2011-06-07 15:24:54Z

3

well if you have myVar already then

funnies_list = Funnies.objects.filter(category__name=myVar)

would work.

answered Jun 7, 2011 at 15:24

JamesO

26.2k4 gold badges44 silver badges42 bronze badges

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

Collectives™ on Stack Overflow

Filtering query with a foreign key

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related