Platforms list is not sorted anymore

[markkuleinio]

After the recent 4.6.2 and 4.6.7 upgrades I realized that the Platforms list is not alphabetically sorted anymore. It is not sorted by the object ID number either.

The same (dis)ordering can be seen in the Platform field of a VM.

The same effect is seen in three separate upgraded NetBox instances with different kind of data.

However, I was not able to reproduce this on a clean(er) NetBox 4.6.7 setup by just adding a few platforms to an otherwise empty platforms list.

Any ideas what's happening? I'm pretty sure that with 4.4.x and previous versions the list has always been alphabetically sorted.

I don't use parents with the platforms, but I see some relatively recent developments in the platforms related to parent functionality.

[markkuleinio]

For those who speak Django ORM:

markku@test:~$ sudo /opt/netbox/venv/bin/python /opt/netbox/netbox/manage.py nbshell
### NetBox interactive shell (test)
### Python v3.13.5 | Django v6.0.7 | NetBox Community v4.6.7
### lsapps() & lsmodels() will show available models. Use help(<model>) for more info.
>>> from dcim.models import Platform
>>> qs = Platform.objects.all()
>>> print(qs.ordered)
True
>>> print(qs.query)
SELECT "dcim_platform"."id", "dcim_platform"."created", "dcim_platform"."last_updated", "dcim_platform"."custom_field_data", "dcim_platform"."owner_id", "dcim_platform"."parent_id", "dcim_platform"."name", "dcim_platform"."slug", "dcim_platform"."description", "dcim_platform"."comments", "dcim_platform"."manufacturer_id", "dcim_platform"."config_template_id", "dcim_platform"."lft", "dcim_platform"."rght", "dcim_platform"."tree_id", "dcim_platform"."level"
FROM "dcim_platform"
ORDER BY "dcim_platform"."tree_id" ASC, "dcim_platform"."lft" ASC
>>>

while for example the Device object results in

ORDER BY "dcim_device"."name" ASC, "dcim_device"."id" ASC

[markkuleinio]

Will open an issue on this.

(#22876)