Django and ForeignKey?

Question

Django

There is this model:

class Menu(models.Model):                                                                                                                                <br>
    name = models.CharField(max_length=255)<br>
    ....                                                                                  <br>
    parent = models.ForeignKey('self', null=True, blank=True)

I make a selection: this results in a query with a join like this:
menu = Menu.objects.filter(parent__isnull=True)

SELECT "menu_menu".*<br>
FROM "menu_menu"<br>
    LEFT OUTER JOIN "menu_menu" T2 ON ("menu_menu"."parent_id" = T2."id")<br>
WHERE T2."id" IS NULL<br>

that is, djanga thinks that parent in this case is not a field, but another model. I've tried adding related_name but to no avail. Does anyone know what's the problem?

Answer 1

I often saw a picture when the Dzhang ORM generates such requests. Alternatively, you can write a raw query.