Django model filter avoid join when filtering by relation id

Question

Django ORM query

projects = Project.objects.filter(category__id=1111)

This generates following sql query, [join used]

""""
select * 
FROM "project" 
INNER JOIN "category" ON ( "project"."category_id" = "category"."id" ) 
WHERE "project"."category_id" = 1111
""""

Is it possible to avoid join and get result like this?

""""
select * 
FROM "project" 
WHERE "project"."category_id" = 1111
""""

Daniel Roseman · Accepted Answer · 2018-03-21 11:27:22Z

1

The underlying db column is called category_id (with a single underscore); you can filter on that directly:

projects = Project.objects.filter(category_id=1111)

answered Mar 21, 2018 at 11:27

Daniel Roseman

602k68 gold badges910 silver badges923 bronze badges

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

1 Answer 1