How to fetch data in date range?

Question

Django

I use Django Rest API, before serialization, I need to pull data from the database in the date range from "2020-01-05" to "2020-01-28".

class User(models.Model):
    first_name = models.CharField(max_length=50)
    last_name = models.CharField(max_length=50)


class Statistic(models.Model):
    user_id = models.ForeignKey(User, on_delete=models.CASCADE, related_name='statistic')
    date = models.DateField()
    page_views = models.IntegerField()

I can pull out the statistics in the range

User.objects.get(pk=pk).statistic.exclude(date__gte='2020-01-18').filter(date__gte='2019-01-08')

It gives me only data from the Statistic table, and User as such disappears.
How to get a sample of statistics in the date range in the User object?

Thanks in advance

Answer 1

Something like:

User.objects.filter(statistic__date__range=['2019-01-08', '2020-01-18'])

did not try?