How do you aggregate a query based on a boolean field?

Question

I have this Article model for a news site with a boolean field called "sticky". The idea is that when the author writes an article and marks it as sticky it should always stay at the top of the list of articles. I wrote a template tag and here's my render method:

def render(self, context):
    context[self.varname] = self.model._default_manager.filter(current_issue__isnull=True, issue__isnull=True).live().order_by('-created_at')
    return ''

This query is where I want to aggregate the sticky articles at the top of the list. How do I do this?

Answer 1

Order by sticky, then order by created_at.