Legend:

Looking at the mptt example [http://code.djangoproject.com/wiki/ModifiedPreorderTreeTraversal] it seemed a bit complicated for a normal user to understand. So i made my own, but considering i cannot group by makes aggregate functions hard (impossible?) to make this work nice, but magic-removal made it easier. Currently only works in postgesql and only tested in 8.1. Use at will and own RISK, but if/ when you improve it i would like to see it made available.

1

Looking at the mptt example [http://code.djangoproject.com/wiki/ModifiedPreorderTreeTraversal] it seemed a bit complicated for a normal user to understand. So i made my own, but considering i cannot group by makes aggregate functions hard to make this work nice, but magic-removal made it easier. Currently only works in postgesql and only tested in 8.1. Use at will and own RISK, but if/ when you improve it i would like to see it made available.

2

2

3

I attach the file and give a example here. Just add fields to this and in should work.

3

I attach the file and give a example here. Just add fields to this and it should work.

4

4

5

5

Remember to set the TABLE variable at the top of models to appname_model.