Enable filtering for null numeric values using the empty lookup #8526

Closed
opened 2025-12-29 20:37:47 +01:00 by adam · 1 comment
Owner

Originally created by @jeremystretch on GitHub (Aug 28, 2023).

Originally assigned to: @jeremystretch on GitHub.

NetBox version

v3.5.8

Feature type

New functionality

Proposed functionality

NetBox currently supports checking for empty string fields using the empty lookup (e.g. ?description__empty=true). This FR proposes extending that functionality to numeric fields as well, to match null/non-null values.

Use case

This enables a user to query numeric fields generally for null or non-null values. For example, ?position__empty=true would return devices which do not have a rack position defined.

Database changes

No response

External dependencies

No response

Originally created by @jeremystretch on GitHub (Aug 28, 2023). Originally assigned to: @jeremystretch on GitHub. ### NetBox version v3.5.8 ### Feature type New functionality ### Proposed functionality NetBox currently supports checking for empty string fields using the `empty` lookup (e.g. `?description__empty=true`). This FR proposes extending that functionality to numeric fields as well, to match null/non-null values. ### Use case This enables a user to query numeric fields generally for null or non-null values. For example, `?position__empty=true` would return devices which do not have a rack position defined. ### Database changes _No response_ ### External dependencies _No response_
adam added the status: acceptedtype: feature labels 2025-12-29 20:37:47 +01:00
adam closed this issue 2025-12-29 20:37:47 +01:00
Author
Owner

@stavr666 commented on GitHub (Aug 29, 2023):

Greatly appreciate this FR and instant implementation 👍🏿

@stavr666 commented on GitHub (Aug 29, 2023): Greatly appreciate this FR and instant implementation 👍🏿
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#8526