[Fixed]-Django and MPTT – get only leaf nodes

Category.objects.filter(children__isnull=True)

Unoptimal solution:

Category.objects.filter(id__in=[category.id for category in Category.objects.all() if category.is_leaf_node()])

My little snippet for django mptt

from django.db import models

class CategoryManager(models.Manager):
    def get_leaf(self, level=2):
        return self.filter(level__lte=level).order_by('tree_id','lft').all()

class Category(models.Model):
     objects = CategoryManager()

profit, use it: Catalog.objects.get_leaf()

From docs:

is_leaf_node()

Returns True if this model instance is a leaf node (it has no children), False otherwise.