tags:

views:

16

answers:

0
+1  Q: 

Sorting&grouping QuerySet data in Django

I have BlogEntry model, which has two special fields : "publication_date"(timestamp), "sticky"(boolean).

i need to get them in order by "publication_date", and group by "sticky" field that have to be first in query set.

what i try to get:
[
<BlogEntry:"05.03.2010 sticky:1">,
<BlogEntry:"04.03.2010 sticky:1">,
<BlogEntry:"03.03.2010 sticky:1">,
<BlogEntry:"02.03.2010 sticky:1">
<BlogEntry:"08.03.2010 sticky:0">,
<BlogEntry:"07.03.2010 sticky:0">,
<BlogEntry:"06.03.2010 sticky:0">,
<BlogEntry:"01.03.2010 sticky:0">
]
]

related questions

Beginner: Trying to understand how apps interact in Django
Django dynamic OR queries
How do I find the "concrete class" of a django model baseclass
Looking for input in model design for Django Schools
How do I create trivial customized field types in Django models?
Foreign key from one app into another in Django
Django: How can I protect against concurrent modification of data base entries
Using django how can I combine two queries from separate models into one query?
Admin generic inlines for multi-table subclassed models broken --- any alternatives?
In Django, how does one filter a QuerySet with dynamic field lookups?
Django foreign key access in save() function
"Unknown column 'user_id' error in django view
Django: How do I model a tree of heterogeneous data types?
How can one get the set of all classes with reverse relationships for a model in Django?
Can you achieve a case insensitive 'unique' constraint in Sqlite3 (with Django)?
designing model structure for django
In django, how do I sort a model on a field and then get the last item?
Single Table Inheritance in Django
How do I restrict foreign keys choices to related objects only in django
Generate JavaScript objects out of Django Models
Django with custom, non-SQL service to store models?
Database and version control system.
In Django how do I notify a parent when a child is saved in a foreign key relationship?
Django signals vs. overriding save method
Represent Ordering in a Relational Database