Recursive model queries

22 views
Skip to first unread message

Shekar Tippur

unread,
Aug 26, 2015, 3:47:39 AM8/26/15
to Django users

Hello,


I need to be able to run query on a recursive model that gives the name of the parent and child

My model

class RecursiveModel(models.Model):
   stage_title = models.CharField(max_length=255, unique=True)
    parent = models.ForeignKey('self', null=True)

I need to get the names of parent and child relationship
Equivalant query being:

select c.id, c.stage_title as child, p.stage_title as parent from recursivemodel c, recursivemodel p  where c.parent_id=p.id

How do I do that?

When I run it, I get:

Cannot assign "'stgabc'": "RecursiveModel_Deferred_created_data_parent_id_stage_title.parent" must be a "RecursiveModel" instance.

- Shekar
Reply all
Reply to author
Forward
0 new messages