Opened 10 years ago

Closed 9 years ago

Last modified 9 years ago

#1298 closed enhancement (invalid)

allow customized sort in model.get_list() and META ordering

Reported by: mattimustang@… Owned by: adrian
Component: Core (Other) Version:
Severity: normal Keywords:
Cc: Triage Stage: Unreviewed
Has patch: no Needs documentation: no
Needs tests: no Patch needs improvement: no
Easy pickings: UI/UX:


I would like to be able to sort a field by more than just its alpha or numerical ascending/descending order:

eg. With the model:

class A(meta.Model):
    ip = meta.IPAddressField()
    class META: ordering = ['ip']

The list of IP's gets sorted like this:

rather than how I would like to have it sorted:

Is it possible to add a model.get_list(order_by=('ip', sort_ip_function)) or as well as some equivalent in META like 'ordering = (('ip', sort_ip_function),)' option to allow some kind of customized sorting to happen?



ps. Do Managers in magic-removal address this?

Change History (2)

comment:1 Changed 10 years ago by lukeplant

Django does all it's ordering using SQL, so this isn't feasible. You could do extra ordering after retrieving the data, but it wouldn't work as expected: these don't do the same thing:

[get all items] -> [sort by (1 then 2)]

[get all items] -> [sort by 1] -> [sort by 2]

The only way to do this at all would be to use some server side custom sorting function, which would depend on what is available with your choice of database.

comment:2 Changed 9 years ago by adrian

  • Resolution set to invalid
  • Status changed from new to closed

Closing for the reason Luke pointed out above.

Note: See TracTickets for help on using tickets.
Back to Top