netbox icon indicating copy to clipboard operation
netbox copied to clipboard

Enhancements on filtering objects by date

Open FliesLikeABrick opened this issue 1 year ago • 4 comments

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

FliesLikeABrick avatar Jun 10 '24 20:06 FliesLikeABrick

@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 avatar Jun 11 '24 15:06 arthanson

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] avatar Jun 19 '24 04:06 github-actions[bot]

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

FliesLikeABrick avatar Jun 20 '24 18:06 FliesLikeABrick

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 avatar Jul 02 '24 12:07 jeremystretch

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] avatar Jul 10 '24 04:07 github-actions[bot]

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] avatar Jul 18 '24 04:07 github-actions[bot]