How would you sort a django mptt tree?

Question

Imagine that I have an mptt tree of objects and their population like:

Animal, 60

Vegetable, 6

Mineral 0

How would you sort the above by population on each sublevel? I want to get to:

Animal, 60

Vegetable, 6

Mineral 0

I am building off of mptt in django.

A link to the topic in question would be useful http://code.google.com/p/django-mptt/ — Andriy Drozdyuk, May 26 '09 at 18:51

score 0 · Answer 1 · edited Oct 30 '13 at 13:18

0

I've just solved a similar issue. You can use an order_by, but not simply by the field you want to sort by:

MyModel.tree.all().order_by('tree_id', 'level', 'your_sort_field')

edited Oct 30 '13 at 13:18

answered Oct 30 '13 at 12:59

affan

score 0 · Answer 2 · answered May 17 '09 at 06:43

0

Try to add it in the models.py Meta Class.

Or on a subsidiary QuerySet

answered May 17 '09 at 06:43

Andre Bossard

score 0 · Answer 3 · edited Feb 24 '10 at 10:40

0

Should an order_by simply work?

YourModel.tree.filter(your=stuff).order_by('order')

edited Feb 24 '10 at 10:40

Dominic Rodger

answered May 17 '09 at 10:56

msmart

3 Answers3