Improve natural sorting with mixed Gi/Te interfaces #1763

New Issue

adam · 2025-12-29T17:18:54+01:00

adam commented

2025-12-29 17:18:54 +01:00

Originally created by @candlerb on GitHub (Jun 1, 2018).

Issue type

[X] Feature request
[ ] Bug report
[ ] Documentation

Environment

Python version: 3.5.2
NetBox version: 2.3.3

Description

I realise that natural sorting is a difficult issue, but here is another anomoly: this is from a Dell Powerconnect N1548 which has Gi1/0/1-1/0/48 and Te1/0/1-1/0/4

It would be nice if natural sorting split the port name into (non-numeric) and (numeric) parts, and sorted them piecewise: when comparing the string parts use string ordering, when comparing the numeric parts compare numerically.

>>> ["Gi", 1, "/", 0, "/", 48] < ["Te", 1, "/", 0, "/", 1]
True

This would mean that all the "Gi" interfaces would come before all the "Te" interfaces.

When comparing a string with a number then pick a fixed order (e.g. string always comes before number).

Originally created by @candlerb on GitHub (Jun 1, 2018). ### Issue type [X] Feature request  [ ] Bug report  [ ] Documentation  ### Environment * Python version: 3.5.2 * NetBox version: 2.3.3 ### Description I realise that natural sorting is a difficult issue, but here is another anomoly: this is from a Dell Powerconnect N1548 which has Gi1/0/1-1/0/48 and Te1/0/1-1/0/4 ![image](https://user-images.githubusercontent.com/44789/40837405-4678dbb0-6592-11e8-8ca1-da37825f6f1d.png) It would be nice if natural sorting split the port name into (non-numeric) and (numeric) parts, and sorted them piecewise: when comparing the string parts use string ordering, when comparing the numeric parts compare numerically. ~~~ >>> ["Gi", 1, "/", 0, "/", 48] < ["Te", 1, "/", 0, "/", 1] True ~~~ This would mean that all the "Gi" interfaces would come before all the "Te" interfaces. When comparing a string with a number then pick a fixed order (e.g. string always comes before number).

adam closed this issue

2025-12-29 17:18:54 +01:00

adam commented

2025-12-29 17:18:55 +01:00

@jeremystretch commented on GitHub (Jun 1, 2018):

Changing the interface ordering on the DeviceType from slot/position to name will order all Gi interfaces before all Te interfaces. NetBox supports both approaches because different platforms follow one or the other.

@jeremystretch commented on GitHub (Jun 1, 2018): Changing the interface ordering on the DeviceType from slot/position to name will order all `Gi` interfaces before all `Te` interfaces. NetBox supports both approaches because different platforms follow one or the other.

adam commented

2025-12-29 17:18:55 +01:00

@candlerb commented on GitHub (Jun 1, 2018):

Cool, that works. I thought it might put Gi1/0/10 before Gi1/0/2, but it doesn't :-)

Thank you!

@candlerb commented on GitHub (Jun 1, 2018): Cool, that works. I thought it might put Gi1/0/10 before Gi1/0/2, but it doesn't :-) Thank you!

Sign in to join this conversation.

Branches Tags

main

update-changelog-comments-docs

feature-removal-issue-type

20911-dropdown

20239-plugin-menu-classes-mutable-state

21097-graphql-id-lookups

feature

fix_module_substitution

20923-dcim-templates

20044-elevation-stuck-lightmode

feature-ip-prefix-link

v4.5-beta1-release

20068-import-moduletype-attrs

20766-fix-german-translation-code-literals

20378-del-script

7604-filter-modifiers-v3

circuit-swap

12318-case-insensitive-uniqueness

20637-improve-device-q-filter

20660-script-load

19724-graphql

20614-update-ruff

14884-script

02496-max-page

19720-macaddress-interface-generic-relation

19408-circuit-terminations-export-templates

20203-openapi-check

fix-19669-api-image-download

7604-filter-modifiers

19275-fixes-interface-bulk-edit

fix-17794-get_field_value_return_list

11507-show-aggregate-and-rir-on-api

9583-add_column_specific_search_field_to_tables

1 Participants

Notifications

Due Date

No due date set.

Dependencies

No dependencies set.

Reference: starred/netbox#1763