I don't know if it can be done without extra, maybe something like
this (I have not tested it):
Homeloan.objects.extra(
select={"banker_category": "appname_bankercategory.name"},
tables = ["appname_bankercategory", "appname_banker"],
where = ["appname_bankercategory.id =
appname_banker.bankercategory_id",
"appname_homeloan.banker_id = appname_banker.id"]
)
then you can access banker_category in homeloan objects
and sort it by loan_type and bankercategory.
For complete syntax of extra modifier, see
http://docs.djangoproject.com/en/dev/ref/models/querysets/index.html#extra-select-none-where-none-params-none-tables-none-order-by-none-select-params-none
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to
django-users+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
