See a recent thread here:
http://groups.google.com/group/django-users/browse_thread/thread/0ee03167b7b5e873/850ac8304bf952b4#850ac8304bf952b4
and this query:
mymodel.objects.extra(select={'ordering_field': 'IF(STRCMP
(bbs_tag.name, 'notice'), '',bbs_tag.name)'},
order_by=['ordering_field'])
bbs_tag (=Tag._meta.db_table) should exist in the queryset, so I added
a filter condition: tags__name__contains='' to make Django to perform
a join.
Article.objects.filter(belongs_to=board, tags__name__contains='').extra
(
select={
'_ordering':"CASE bbs_tag.name WHEN 'notice' THEN '' END",
'is_notice2':"bbs_tag.name = 'notice'",
},
order_by=['-_ordering', '-written_at']
But this query produces 7 objects with one duplicated.
(Note that IF clause is a mysql-specific extension, so it's better to
use CASE clause that is standard.)
The result set is a list of Article instances, but inside the query,
tags should be joined and processed.
How do I do this in more clear way?
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
