Support time range constraints for changelog in API

[jakubkrysl]

User Story

As Arthur the API user...,

I want to get changes done over some period...,

So that I don't I don't have to fetch all (600k) object changes…,

I will know this is done when API supports time range constraints in any form (before/after, time__lt/time__gt...).

Note: It is already possible in UI.

Database Changes

None

External Dependencies

None

[scetron]

Hello @Thetacz, if you are using the API, you can use the q query in the following form:

q=&time_after=2021-03-03 12:00:00&time_before=2022-03-03 12:00:00

So in this case, you can try this URL:

http://demo.nautobot.com/api/extras/object-changes/?q=&time_after=2021-03-03 12:00:00&time_before=2022-03-03 12:00:00

Does this work for your use case? Keep in mind, when using the filter, it appears that you have to specify a time range, rather than just before or after.

[joewesch]

I believe you can enable the individual before & after filters if you specify the lte/gte methods in addition to this line:

nautobot/nautobot/extras/filters.py

Line 625 in 1710dd4

time = django_filters.DateTimeFromToRangeFilter()

time__gte = django_filters.DateTimeFilter(field_name="time", lookup_expr="gte")
time__lte = django_filters.DateTimeFilter(field_name="time", lookup_expr="lte")

[scetron]

Thanks @joewesch, actually, explicitly adding those to the FilterSet allows it to be used in GraphQL as well. I'll add that as time_before and time_after.