Cannot Sort By asn_count Column For Sites Table And Providers View Table

[mr1716]

Deployment Type

Self-hosted

NetBox Version

V4.2.0

Python Version

3.10

Steps to Reproduce

1. Add the ‘ASN Count’ Column as an available/default column for the Sites table
2. Click the ‘ASN Count’ column to sort the table by ASN Count
3. Refresh the page

When doing this, I get the error:
`<class 'django.core.exceptions.FieldError'>

Cannot resolve keyword 'count' into field. Choices are: asn, bookmarks, comments, created, custom_field_data, description, device_count, id, journal_entries, last_updated, providers, rir, rir_id, sites, subscriptions, tagged_items, tags, tenant, tenant_id
`

Expected Behavior

It would sort the table based upon ASN Count value

Observed Behavior

It fails and can’t load the Sites Table. I also tested and verified this is an issue that occurs with the online demo system (demo.netbox.dev), so it isnt a customization or something special with my setup that is causing this.

[jnovinger]

@arthanson , this is the one I'm working on.

[bctiemann]

@jnovinger This fix also needs to be applied to ProviderListView, as it has the same issue.

[mr1716]

@bctiemann, would it worth submitting a separate ticket or keeping this one open? Just asking so it can be scoped properly

[jeremystretch]

Let's fix that issue here as well, since these are both effectively the same bug.