Django self-recursive foreignkey filter query for all childs

by

You can always add a recursive function to your model:

EDIT: Corrected according to SeomGi Han

def get_all_children(self, include_self=True):
    r = []
    if include_self:
        r.append(self)
    for c in Person.objects.filter(parent=self):
        _r = c.get_all_children(include_self=True)
        if 0 < len(_r):
            r.extend(_r)
    return r

(Don’t use this if you have a lot of recursion or data …)

Still recommending mptt as suggested by errx.

EDIT: 2021 since this answer is still getting attention :/

Use django-tree-queries instead!

More Related Contents:

  1. Raise a validation error in a model’s save method in Django
  2. Django Queryset with filtering on reverse foreign key
  3. Can Django automatically create a related one-to-one model?
  4. Django Pass Multiple Models to one Template
  5. Django: Using F arguments in datetime.timedelta inside a query
  6. Django: Populate user ID when saving a model
  7. Get model’s fields in Django
  8. Can django’s auth_user.username be varchar(75)? How could that be done?
  9. Manager isn’t available; User has been swapped for ‘pet.Person’
  10. How to get the list of the authenticated users?
  11. Django: How do I add arbitrary html attributes to input fields on a form?
  12. creating my own context processor in django
  13. Get list item dynamically in django templates
  14. Select DISTINCT individual columns in django?
  15. What is the right way to use angular2 http requests with Django CSRF protection?
  16. django admin login suddenly demanding csrf token
  17. How to cURL an Authenticated Django App?
  18. Django – filtering on foreign key properties
  19. CSRF with Django, React+Redux using Axios
  20. Django admin: How to display a field that is marked as editable=False’ in the model?
  21. How do I add a custom column with a hyperlink in the django admin interface?
  22. Django unique_together with nullable ForeignKey
  23. Django lazy QuerySet and pagination
  24. Django – Why should I ever use the render_to_response at all?
  25. Django: ManyToMany filter matching on ALL items in a list
  26. How to add a sortable count column to the Django admin of a model with a many-to-one relation?
  27. ModelForm with OneToOneField in Django
  28. Django: dynamic database file
  29. Get type of Django form widget from within template
  30. How to simplify migrations in Django 1.7?

Leave a Comment