Enhancements on filtering objects by date #9823

Closed
opened 2025-12-29 21:23:12 +01:00 by adam · 6 comments
Owner

Originally created by @FliesLikeABrick on GitHub (Jun 10, 2024).

Originally assigned to: @arthanson on GitHub.

NetBox version

v4.0.5

Feature type

New functionality

Proposed functionality

Allow for filtering dates based on greater than, less than, and/or ranges; This would be valuable for date of creation of records, as well as date/time custom field values.

Additionally, expose "Created date" and "modified date" as fields in filters.

Use case

While testing and documenting workflows for auditing/cleaning up date in our NetBox implementation (chiefly IPAM Prefixes and IP Addresses, but other types as well), we have continued to run into a shortcoming with the ability to provide our administrators with saved filters/queries that can let them review stale items. For example, we can have a saved query for "Prefix with status Reserveed", but cannot do a key part such as "created before 6 months ago".

We want to perform such queries based on created date, modified date, and custom fields specific to our environment.

The only way we can do this today is by exporting large amounts of data to Excel, and filtering there; or by using the API with custom tooling which is not as accessible to our administrators/supportable in our environment.

Database changes

No response

External dependencies

No response

Originally created by @FliesLikeABrick on GitHub (Jun 10, 2024). Originally assigned to: @arthanson on GitHub. ### NetBox version v4.0.5 ### Feature type New functionality ### Proposed functionality Allow for filtering dates based on greater than, less than, and/or ranges; This would be valuable for date of creation of records, as well as date/time custom field values. Additionally, expose "Created date" and "modified date" as fields in filters. ### Use case While testing and documenting workflows for auditing/cleaning up date in our NetBox implementation (chiefly IPAM Prefixes and IP Addresses, but other types as well), we have continued to run into a shortcoming with the ability to provide our administrators with saved filters/queries that can let them review stale items. For example, we can have a saved query for "Prefix with status Reserveed", but cannot do a key part such as "created before 6 months ago". We want to perform such queries based on created date, modified date, and custom fields specific to our environment. The only way we can do this today is by exporting large amounts of data to Excel, and filtering there; or by using the API with custom tooling which is not as accessible to our administrators/supportable in our environment. ### Database changes _No response_ ### External dependencies _No response_
adam added the type: featurepending closurestatus: revisions needed labels 2025-12-29 21:23:12 +01:00
adam closed this issue 2025-12-29 21:23:12 +01:00
Author
Owner

@arthanson commented on GitHub (Jun 11, 2024):

@FliesLikeABrick are you looking for something like what is in Jobs (see screenshot) and would this be for just the API or in the UI?
Monosnap Jobs | NetBox 2024-06-11 08-37-34

@arthanson commented on GitHub (Jun 11, 2024): @FliesLikeABrick are you looking for something like what is in Jobs (see screenshot) and would this be for just the API or in the UI? ![Monosnap Jobs | NetBox 2024-06-11 08-37-34](https://github.com/netbox-community/netbox/assets/99642/00c88df3-4c65-463c-92de-b62106132f0f)
Author
Owner

@github-actions[bot] commented on GitHub (Jun 19, 2024):

This is a reminder that additional information is needed in order to further triage this issue. If the requested details are not provided, the issue will soon be closed automatically.

@github-actions[bot] commented on GitHub (Jun 19, 2024): This is a reminder that additional information is needed in order to further triage this issue. If the requested details are not provided, the issue will soon be closed automatically.
Author
Owner

@FliesLikeABrick commented on GitHub (Jun 20, 2024):

yeah @arthanson exactly something like that but for filtering other objects such as IPAM Prefixes in the UI

@FliesLikeABrick commented on GitHub (Jun 20, 2024): yeah @arthanson exactly something like that but for filtering other objects such as IPAM Prefixes in the UI
Author
Owner

@jeremystretch commented on GitHub (Jul 2, 2024):

Allow for filtering dates based on greater than, less than, and/or ranges;

@FliesLikeABrick please expand your post above to detail specifically what you are proposing be added and where.

Additionally, expose "Created date" and "modified date" as fields in filters.

This would need to be a separate FR, and again needs more detail.

@jeremystretch commented on GitHub (Jul 2, 2024): > Allow for filtering dates based on greater than, less than, and/or ranges; @FliesLikeABrick please expand your post above to detail specifically what you are proposing be added and where. > Additionally, expose "Created date" and "modified date" as fields in filters. This would need to be a separate FR, and again needs more detail.
Author
Owner

@github-actions[bot] commented on GitHub (Jul 10, 2024):

This is a reminder that additional information is needed in order to further triage this issue. If the requested details are not provided, the issue will soon be closed automatically.

@github-actions[bot] commented on GitHub (Jul 10, 2024): This is a reminder that additional information is needed in order to further triage this issue. If the requested details are not provided, the issue will soon be closed automatically.
Author
Owner

@github-actions[bot] commented on GitHub (Jul 18, 2024):

This issue is being closed as no further information has been provided. If you would like to revisit this topic, please first modify your original post to include all the requested detail, and then ask that the issue be reopened.

@github-actions[bot] commented on GitHub (Jul 18, 2024): This issue is being closed as no further information has been provided. If you would like to revisit this topic, please first modify your original post to include all the requested detail, and then ask that the issue be reopened.
Sign in to join this conversation.
1 Participants
Notifications
Due Date
No due date set.
Dependencies

No dependencies set.

Reference: starred/netbox#9823