Can Django ORM do an ORDER BY on a specific value of a column?

Question

I have a table 'tickets' with the following columns - id - primary key - auto increment - title - varchar(256) - status - smallint(6) - Can have any value between 1 and 5, handled by Django When I'll do a `SELECT *` I want the rows with `status = 4` at the top, the other records will follow them. It can be achieved by the following query: ``` select * from tickets order by status=4 DESC ``` Can this query be executed through Django ORM? What parameters should be passed to the `QuerySet.order_by()` method?

Accepted Answer

```
q = Ticket.objects.extra(select={'is_top': "status = 4"})
q = q.extra(order_by = ['-is_top'])
```

Can Django ORM do an ORDER BY on a specific value of a column?

Solution

Problem