按日期分组对象 [英] Group objects by dates

问题描述

clicks = SellerClick.objects.extra({'date' : "date(timestamp)"}).values('date').annotate(count=Count('timestamp'))

该模型有一个日期时间字段，名为 timestamp 正在使用。我首先将datetime字段转换为一个日期字段。其余的都在猜测。我需要分组，然后计算每个日期中有多少个对象。

The model has a datetime field called timestamp that was are using. I first, convert the datetime field to just a date field. Then the rest is guessing. I need to group by, and then count how many objects are of each date.

因此，所需的结果将是一个日期，然后是一个计数，基于多少对象在 timestamp 字段中有该日期。

So the desired result would be a date, then a count, based on how many objects have that date in the timestamp field.

推荐答案

我更喜欢使用从django.db.models.expressions import注释额外的

I prefer to use annotate over extra

from django.db.models.expressions import RawSQL  

SellerClick.objects.annotate(
    date=RawSQL('date(date_joined)',[]),
).values('date').annotate(count=Count('date')))

这篇关于按日期分组对象的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！